Question: Using excel use the NORM.S.DIST function on page 212 in your text. First, you need to compute the z-Scores for the raw scores given in

Using excel use the NORM.S.DIST function on page 212 in your text. First, you need to compute the z-Scores for the raw scores given in a., b., c., and d., then use the NORM.S.DIST function to determine the probability value.

1.Questions 6a through 6d are based on a distribution of scores with X=75 and standard deviation =6.38. Draw a picture to help you see what's required.

a.What is the probability of a score falling between a raw score of 70 and 80?

b.What is the probability of a score falling between a raw score of 80?

c.What is the probability of a score falling between a raw score of 81 and 83?

d.What is the probability of a score falling between a raw score of 63?

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!

204 Part III . Taking Chances for Fun and Profit Standard scores are so powerful and useful because they can be compared with one another without regard to their mean or stan- dard deviation values....

BATCH 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67...

Please show Excel formulas. You have been given the following information on a call option on the stock of Puckett Industries: P= $65 X = $70 t= 0.5 TRE= 5% = 0.50 a. Using the Black-Scholes Option...

***Please answer with cell references *** 1 Ruiz Company issued bonds on January 1 and has provided the relevant information. The Controller has asked you to calculate the bond selling price given...

ITM 501: Decision Analysis Homework Assignment 2 Instructions: - The assignment must be submitted through Blackboard. - Submit one spreadsheet file named according to the following format: _ #2.xls...

PowerPoint Assignment for BUS 401: Principles of Finance You have been asked by a manager in your organization to put together a training program explaining Net Present Value (NPV) and Future Value...

Ruiz Company issued bonds on January 1 and has provided the relevant information. The Controller has asked you to calculate the bond selling price given two different market interest rates using...

AutoSave . OFF Ch08 P08 Build a Model Merab Q Qv Home Insert Draw Page Layout Formulas Data Review View Share Comments Times New Roman * 10 A" A" 2 Wrap Text v General 2" AY- O. Paste BIUV V QVAV EE...

How do I type the formulat into the d1 area.... cannot figure it out.. module,6 Excel View Help Corel POF Fusion Tel me what you was File Home Insert Page Layout Formulas Data D16 MI Module 6 Student...

Made by the Tootsie Industries of Chicago, Illinois, Mason Dots is a gumdrop candy. A box was opened by the authors and was found to contain the following number of gumdrops: Orange 9 Lemon 8...

Financial ratios computed for Whittaker Inc. include the following: 1.6 to 1 1.3 to 1 Current ratio Acid-test ratio Debt/equity ratio. Inventory turnover 2.0 to 1 2.5 times 5.8 times 4.80 times...

Asset y has a beta of 1 . 2 . The risk free rate of reture is 6 percent

Speedy Bikes could sell its bicycles to retailers either assembled or unassembled. The cost of an unassembled bike is as follows. Direct materials $150 Direct labor 70 Variable overhead (70% of...