BUSINESS STAT HOMEWORK

profileretred
data_analysis_project_2_data1.xlsx
Home>Mathematics homework help>BUSINESS STAT HOMEWORK

Raw Data

Enter the last four digits of your student number, one digit per column in the following row:
Example: Student number = 1442017 2 0 1 7
Table of Random Variables to use in your calculations (in other worksheets)
Your data: Plan Section Classes Trainer Binomial Poisson Normal
Adult Climbing Wall Yoga/Pilates Often (3-5 times) m or p 0.2513 12.8460 28.2800
Family Climbing Wall Spinning Frequently (>=6x) a = 2 5 5.6560
Gold Racquet Ct. Spinning Zero/Don't Use b = 1 4 36.7772
Gold Climbing Wall Yoga/Pilates Zero/Don't Use c = 5 8 15.1639
Adult Racquet Ct. Boot Camp Often (3-5 times) d= 9 3 4
Adult Treadmill/Ellip. Boot Camp Rarely (1-2 times)
Gold Racquet Ct. Spinning Zero/Don't Use Plan Q1 Q2 Q3
Adult Weight Room Zumba Zero/Don't Use 1 Adult Climbing Wall Zumba Zero/Don't Use
Gold Weight Room Zumba Frequently (>=6x) 2 Family Racquet Ct. Spinning Rarely (1-2 times)
Gold Weight Room Spinning Frequently (>=6x) 3 Gold Weight Room Boot Camp Often (3-5 times)
Gold Treadmill/Ellip. Boot Camp Often (3-5 times) 4 Treadmill/Ellip. Yoga/Pilates Frequently (>=6x)
Adult Weight Room Yoga/Pilates Rarely (1-2 times)
Gold Climbing Wall Boot Camp Frequently (>=6x)
Adult Climbing Wall Yoga/Pilates Often (3-5 times) Q1: Which section do you use the most?
Family Climbing Wall Zumba Zero/Don't Use Q2: Favorite speciality fitness classes taken
Adult Weight Room Boot Camp Frequently (>=6x) Q3: Use of personal trainer in past month
Gold Weight Room Boot Camp Zero/Don't Use
Adult Climbing Wall Zumba Frequently (>=6x)
Family Racquet Ct. Spinning Often (3-5 times)
Adult Weight Room Spinning Rarely (1-2 times)
Adult Treadmill/Ellip. Spinning Often (3-5 times)
Adult Treadmill/Ellip. Spinning Zero/Don't Use
Gold Treadmill/Ellip. Yoga/Pilates Zero/Don't Use
Adult Racquet Ct. Boot Camp Rarely (1-2 times)
Family Weight Room Zumba Often (3-5 times)
Adult Weight Room Zumba Zero/Don't Use
Family Weight Room Boot Camp Often (3-5 times)
Gold Climbing Wall Zumba Rarely (1-2 times)
Adult Racquet Ct. Spinning Zero/Don't Use
Gold Climbing Wall Zumba Zero/Don't Use
Adult Treadmill/Ellip. Boot Camp Often (3-5 times)
Family Weight Room Yoga/Pilates Rarely (1-2 times)
Gold Treadmill/Ellip. Zumba Frequently (>=6x)
Gold Weight Room Boot Camp Zero/Don't Use
Gold Climbing Wall Zumba Rarely (1-2 times)
Adult Treadmill/Ellip. Spinning Often (3-5 times)
Adult Weight Room Zumba Zero/Don't Use
Family Racquet Ct. Boot Camp Frequently (>=6x)
Gold Climbing Wall Zumba Zero/Don't Use
Gold Climbing Wall Spinning Rarely (1-2 times)
Gold Weight Room Yoga/Pilates Zero/Don't Use
Family Weight Room Yoga/Pilates Frequently (>=6x)
Adult Climbing Wall Spinning Rarely (1-2 times)
Adult Racquet Ct. Zumba Often (3-5 times)
Gold Treadmill/Ellip. Boot Camp Zero/Don't Use
Adult Racquet Ct. Boot Camp Often (3-5 times)
Gold Climbing Wall Zumba Often (3-5 times)
Gold Treadmill/Ellip. Yoga/Pilates Frequently (>=6x)
Family Weight Room Spinning Often (3-5 times)
Family Weight Room Zumba Rarely (1-2 times)
Gold Racquet Ct. Zumba Often (3-5 times)
Family Weight Room Zumba Often (3-5 times)
Adult Racquet Ct. Spinning Zero/Don't Use
Family Weight Room Yoga/Pilates Frequently (>=6x)
Adult Climbing Wall Yoga/Pilates Zero/Don't Use
Adult Racquet Ct. Spinning Frequently (>=6x)
Family Treadmill/Ellip. Spinning Often (3-5 times)
Family Racquet Ct. Yoga/Pilates Zero/Don't Use
Gold Climbing Wall Spinning Zero/Don't Use
Gold Treadmill/Ellip. Spinning Frequently (>=6x)
Adult Weight Room Spinning Often (3-5 times)
Adult Weight Room Zumba Often (3-5 times)
Adult Racquet Ct. Spinning Rarely (1-2 times)
Adult Weight Room Boot Camp Zero/Don't Use
Family Weight Room Zumba Zero/Don't Use
Adult Weight Room Zumba Zero/Don't Use
Family Weight Room Yoga/Pilates Rarely (1-2 times)
Gold Racquet Ct. Yoga/Pilates Zero/Don't Use
Adult Treadmill/Ellip. Yoga/Pilates Zero/Don't Use
Gold Weight Room Yoga/Pilates Zero/Don't Use
Adult Treadmill/Ellip. Boot Camp Rarely (1-2 times)
Family Climbing Wall Spinning Frequently (>=6x)
Gold Weight Room Zumba Rarely (1-2 times)
Adult Treadmill/Ellip. Zumba Rarely (1-2 times)
Family Treadmill/Ellip. Boot Camp Rarely (1-2 times)
Gold Climbing Wall Yoga/Pilates Zero/Don't Use
Adult Weight Room Yoga/Pilates Frequently (>=6x)
Gold Treadmill/Ellip. Spinning Frequently (>=6x)
Family Treadmill/Ellip. Zumba Frequently (>=6x)
Gold Weight Room Yoga/Pilates Often (3-5 times)
Adult Weight Room Zumba Often (3-5 times)
Gold Climbing Wall Boot Camp Often (3-5 times)
Family Climbing Wall Spinning Zero/Don't Use
Family Climbing Wall Boot Camp Often (3-5 times)
Adult Racquet Ct. Yoga/Pilates Rarely (1-2 times)
Family Racquet Ct. Boot Camp Rarely (1-2 times)
Adult Weight Room Yoga/Pilates Zero/Don't Use
Gold Climbing Wall Zumba Often (3-5 times)
Gold Weight Room Spinning Frequently (>=6x)
Adult Racquet Ct. Yoga/Pilates Frequently (>=6x)
Family Treadmill/Ellip. Zumba Often (3-5 times)
Adult Climbing Wall Spinning Zero/Don't Use
Family Racquet Ct. Zumba Often (3-5 times)
Gold Racquet Ct. Boot Camp Frequently (>=6x)
Adult Treadmill/Ellip. Spinning Often (3-5 times)
Adult Racquet Ct. Yoga/Pilates Often (3-5 times)
Gold Weight Room Zumba Zero/Don't Use
Gold Treadmill/Ellip. Spinning Rarely (1-2 times)
Adult Treadmill/Ellip. Spinning Zero/Don't Use
Gold Weight Room Yoga/Pilates Often (3-5 times)
Family Climbing Wall Spinning Often (3-5 times)
Gold Climbing Wall Boot Camp Often (3-5 times)
Adult Climbing Wall Spinning Frequently (>=6x)
Gold Climbing Wall Yoga/Pilates Frequently (>=6x)
Family Racquet Ct. Zumba Often (3-5 times)
Family Treadmill/Ellip. Spinning Rarely (1-2 times)
Gold Weight Room Spinning Often (3-5 times)
Adult Treadmill/Ellip. Boot Camp Zero/Don't Use
Gold Climbing Wall Spinning Frequently (>=6x)
Gold Climbing Wall Boot Camp Frequently (>=6x)
Family Climbing Wall Boot Camp Zero/Don't Use
Family Treadmill/Ellip. Zumba Rarely (1-2 times)
Gold Climbing Wall Zumba Zero/Don't Use
Gold Climbing Wall Zumba Zero/Don't Use
Family Climbing Wall Boot Camp Zero/Don't Use
Gold Weight Room Boot Camp Frequently (>=6x)
Adult Treadmill/Ellip. Boot Camp Rarely (1-2 times)
Family Weight Room Zumba Often (3-5 times)
Gold Racquet Ct. Zumba Frequently (>=6x)
Gold Treadmill/Ellip. Zumba Zero/Don't Use
Family Climbing Wall Yoga/Pilates Zero/Don't Use
Family Racquet Ct. Yoga/Pilates Often (3-5 times)
Gold Treadmill/Ellip. Spinning Rarely (1-2 times)
Adult Racquet Ct. Zumba Zero/Don't Use
Adult Weight Room Zumba Rarely (1-2 times)
Gold Weight Room Zumba Rarely (1-2 times)
Adult Climbing Wall Zumba Frequently (>=6x)
Family Racquet Ct. Yoga/Pilates Often (3-5 times)
Adult Treadmill/Ellip. Yoga/Pilates Zero/Don't Use
Family Weight Room Boot Camp Zero/Don't Use
Gold Weight Room Zumba Frequently (>=6x)
Adult Weight Room Zumba Zero/Don't Use
Gold Weight Room Spinning Rarely (1-2 times)
Family Weight Room Yoga/Pilates Zero/Don't Use
Adult Treadmill/Ellip. Boot Camp Often (3-5 times)
Family Weight Room Spinning Often (3-5 times)
Gold Weight Room Yoga/Pilates Often (3-5 times)
Gold Racquet Ct. Yoga/Pilates Frequently (>=6x)
Adult Treadmill/Ellip. Spinning Zero/Don't Use
Adult Climbing Wall Zumba Frequently (>=6x)
Gold Racquet Ct. Zumba Often (3-5 times)
Adult Climbing Wall Zumba Frequently (>=6x)
Gold Climbing Wall Spinning Rarely (1-2 times)
Gold Weight Room Yoga/Pilates Often (3-5 times)
Gold Racquet Ct. Yoga/Pilates Zero/Don't Use
Gold Racquet Ct. Spinning Zero/Don't Use
Adult Treadmill/Ellip. Yoga/Pilates Often (3-5 times)
Family Weight Room Boot Camp Zero/Don't Use
Gold Weight Room Zumba Zero/Don't Use
Family Racquet Ct. Boot Camp Often (3-5 times)
Gold Treadmill/Ellip. Zumba Often (3-5 times)
Gold Treadmill/Ellip. Spinning Zero/Don't Use
Gold Climbing Wall Spinning Zero/Don't Use
Adult Weight Room Boot Camp Frequently (>=6x)
Gold Treadmill/Ellip. Boot Camp Frequently (>=6x)
Gold Weight Room Zumba Frequently (>=6x)
Adult Treadmill/Ellip. Spinning Zero/Don't Use
Adult Treadmill/Ellip. Spinning Often (3-5 times)
Gold Climbing Wall Boot Camp Zero/Don't Use
Adult Weight Room Boot Camp Rarely (1-2 times)
Adult Climbing Wall Yoga/Pilates Zero/Don't Use
Family Treadmill/Ellip. Spinning Rarely (1-2 times)
Family Weight Room Boot Camp Zero/Don't Use
Adult Climbing Wall Spinning Frequently (>=6x)
Family Weight Room Zumba Often (3-5 times)
Adult Racquet Ct. Yoga/Pilates Frequently (>=6x)
Adult Treadmill/Ellip. Spinning Frequently (>=6x)
Adult Weight Room Spinning Rarely (1-2 times)
Adult Treadmill/Ellip. Spinning Often (3-5 times)
Family Treadmill/Ellip. Zumba Often (3-5 times)
Adult Weight Room Zumba Rarely (1-2 times)
Gold Weight Room Zumba Rarely (1-2 times)
Adult Weight Room Yoga/Pilates Frequently (>=6x)
Gold Racquet Ct. Yoga/Pilates Frequently (>=6x)
Gold Treadmill/Ellip. Zumba Rarely (1-2 times)
Family Climbing Wall Boot Camp Rarely (1-2 times)
Adult Climbing Wall Boot Camp Often (3-5 times)
Adult Weight Room Yoga/Pilates Rarely (1-2 times)
Adult Treadmill/Ellip. Zumba Zero/Don't Use
Gold Racquet Ct. Yoga/Pilates Rarely (1-2 times)
Gold Weight Room Boot Camp Zero/Don't Use
Adult Climbing Wall Yoga/Pilates Frequently (>=6x)
Family Treadmill/Ellip. Zumba Frequently (>=6x)
Family Treadmill/Ellip. Spinning Zero/Don't Use
Adult Treadmill/Ellip. Boot Camp Zero/Don't Use
Family Weight Room Zumba Often (3-5 times)
Adult Climbing Wall Spinning Rarely (1-2 times)
Family Racquet Ct. Spinning Rarely (1-2 times)
Gold Racquet Ct. Spinning Frequently (>=6x)
Family Racquet Ct. Yoga/Pilates Rarely (1-2 times)
Adult Racquet Ct. Yoga/Pilates Often (3-5 times)
Family Treadmill/Ellip. Boot Camp Zero/Don't Use
Adult Racquet Ct. Spinning Rarely (1-2 times)
Adult Climbing Wall Boot Camp Zero/Don't Use
Family Racquet Ct. Spinning Zero/Don't Use
Gold Racquet Ct. Zumba Zero/Don't Use
Gold Weight Room Yoga/Pilates Frequently (>=6x)
Family Treadmill/Ellip. Zumba Zero/Don't Use
Family Weight Room Zumba Rarely (1-2 times)
Gold Treadmill/Ellip. Zumba Often (3-5 times)
Gold Weight Room Boot Camp Rarely (1-2 times)
Gold Treadmill/Ellip. Spinning Rarely (1-2 times)
Adult Climbing Wall Boot Camp Zero/Don't Use
Family Treadmill/Ellip. Yoga/Pilates Zero/Don't Use
Family Weight Room Zumba Rarely (1-2 times)
Adult Climbing Wall Boot Camp Frequently (>=6x)
Gold Racquet Ct. Spinning Zero/Don't Use
Gold Racquet Ct. Spinning Often (3-5 times)
Gold Racquet Ct. Zumba Often (3-5 times)
Family Weight Room Zumba Zero/Don't Use
Adult Weight Room Zumba Frequently (>=6x)
Family Racquet Ct. Boot Camp Frequently (>=6x)
Adult Racquet Ct. Yoga/Pilates Often (3-5 times)
Family Treadmill/Ellip. Zumba Frequently (>=6x)
Adult Treadmill/Ellip. Boot Camp Often (3-5 times)
Family Treadmill/Ellip. Zumba Rarely (1-2 times)
Family Weight Room Boot Camp Often (3-5 times)
Family Climbing Wall Boot Camp Often (3-5 times)
Gold Racquet Ct. Boot Camp Zero/Don't Use
Adult Racquet Ct. Boot Camp Frequently (>=6x)
Family Racquet Ct. Zumba Zero/Don't Use
Adult Treadmill/Ellip. Zumba Often (3-5 times)
Family Racquet Ct. Zumba Frequently (>=6x)
Family Climbing Wall Zumba Rarely (1-2 times)
Gold Weight Room Yoga/Pilates Frequently (>=6x)
Gold Racquet Ct. Zumba Often (3-5 times)
Adult Climbing Wall Zumba Often (3-5 times)
Gold Racquet Ct. Boot Camp Frequently (>=6x)
Family Climbing Wall Spinning Zero/Don't Use
Adult Weight Room Yoga/Pilates Zero/Don't Use
Adult Climbing Wall Spinning Rarely (1-2 times)
Adult Weight Room Boot Camp Rarely (1-2 times)
Adult Treadmill/Ellip. Boot Camp Often (3-5 times)
Gold Weight Room Zumba Zero/Don't Use
Family Weight Room Yoga/Pilates Rarely (1-2 times)
Gold Climbing Wall Yoga/Pilates Rarely (1-2 times)
Gold Racquet Ct. Spinning Often (3-5 times)
Adult Weight Room Zumba Frequently (>=6x)
Family Climbing Wall Yoga/Pilates Zero/Don't Use
Gold Weight Room Boot Camp Rarely (1-2 times)
Adult Weight Room Yoga/Pilates Often (3-5 times)
Gold Weight Room Spinning Rarely (1-2 times)
Adult Weight Room Spinning Zero/Don't Use
Family Climbing Wall Spinning Frequently (>=6x)
Gold Treadmill/Ellip. Spinning Frequently (>=6x)
Gold Racquet Ct. Yoga/Pilates Zero/Don't Use
Family Weight Room Zumba Frequently (>=6x)
Gold Treadmill/Ellip. Zumba Rarely (1-2 times)
Gold Racquet Ct. Zumba Rarely (1-2 times)
Family Climbing Wall Spinning Often (3-5 times)
Adult Treadmill/Ellip. Spinning Frequently (>=6x)
Gold Racquet Ct. Zumba Often (3-5 times)
Family Racquet Ct. Yoga/Pilates Frequently (>=6x)
Gold Racquet Ct. Spinning Often (3-5 times)
Family Climbing Wall Zumba Frequently (>=6x)
Gold Treadmill/Ellip. Boot Camp Frequently (>=6x)
Family Treadmill/Ellip. Boot Camp Zero/Don't Use
Adult Weight Room Boot Camp Zero/Don't Use
Adult Racquet Ct. Spinning Frequently (>=6x)
Gold Weight Room Boot Camp Rarely (1-2 times)
Adult Treadmill/Ellip. Yoga/Pilates Frequently (>=6x)
Adult Climbing Wall Yoga/Pilates Zero/Don't Use
Adult Racquet Ct. Zumba Often (3-5 times)
Family Weight Room Boot Camp Frequently (>=6x)
Family Racquet Ct. Zumba Frequently (>=6x)
Adult Treadmill/Ellip. Yoga/Pilates Often (3-5 times)
Family Weight Room Spinning Rarely (1-2 times)
Gold Weight Room Yoga/Pilates Often (3-5 times)
Gold Weight Room Boot Camp Zero/Don't Use
Adult Racquet Ct. Spinning Rarely (1-2 times)
Gold Treadmill/Ellip. Spinning Rarely (1-2 times)
Adult Treadmill/Ellip. Yoga/Pilates Often (3-5 times)
Family Weight Room Boot Camp Often (3-5 times)
Family Treadmill/Ellip. Yoga/Pilates Often (3-5 times)
Gold Treadmill/Ellip. Spinning Often (3-5 times)
Family Climbing Wall Boot Camp Zero/Don't Use
Gold Racquet Ct. Boot Camp Rarely (1-2 times)
Gold Racquet Ct. Yoga/Pilates Rarely (1-2 times)
Family Treadmill/Ellip. Yoga/Pilates Rarely (1-2 times)
Adult Climbing Wall Spinning Frequently (>=6x)
Gold Racquet Ct. Boot Camp Often (3-5 times)
Adult Weight Room Spinning Frequently (>=6x)
Gold Treadmill/Ellip. Boot Camp Frequently (>=6x)
Family Climbing Wall Boot Camp Often (3-5 times)
Adult Racquet Ct. Yoga/Pilates Often (3-5 times)
Gold Treadmill/Ellip. Yoga/Pilates Rarely (1-2 times)
Adult Climbing Wall Yoga/Pilates Zero/Don't Use
Adult Treadmill/Ellip. Yoga/Pilates Rarely (1-2 times)
Gold Treadmill/Ellip. Spinning Often (3-5 times)
Family Treadmill/Ellip. Zumba Frequently (>=6x)
Family Racquet Ct. Boot Camp Zero/Don't Use
Gold Weight Room Boot Camp Frequently (>=6x)
Family Racquet Ct. Boot Camp Zero/Don't Use
Gold Racquet Ct. Yoga/Pilates Often (3-5 times)
Family Treadmill/Ellip. Zumba Rarely (1-2 times)
Family Weight Room Yoga/Pilates Rarely (1-2 times)
Family Treadmill/Ellip. Spinning Often (3-5 times)
Adult Treadmill/Ellip. Yoga/Pilates Frequently (>=6x)
Adult Climbing Wall Yoga/Pilates Often (3-5 times)
Adult Weight Room Spinning Often (3-5 times)

My Data

Copy the VALUES from the Raw Data worksheet here. See the project directions for how to do this.
You will use these values to do calculations and tables for this project, NOT the values in the raw data worksheet.
If you do this correctly, there will be NO FORMULAS whatsoever in this workhsheet, only an unique copy of your raw data worksheet without formulas (just numbers)

Contingency Table

1. Insert one pivot table of your choice comparing plans against either Q1, Q2, or Q3. Your pivot should reflect the frequency in each category.
2. Answer the following questions based on your table: *
a. Given that someone is on the adult plan, (answer ONE of the three below depending on the pivot table chosen)
….. What is the probability that they use the climbing wall? OR ANSWER = < Do not just type in your final answer. Show me how you calculated it in the yellow boxes
….. What is the probability that they prefer boot camp classes? OR
….. What is the probability that they do not use a personal trainer?
b. What is the probability that (answer ONE of the three below depending on your pivot table)
….. Someone is on the Gold Plan or uses the weight room the most? OR ANSWER = < Do not just type in your final answer. Show me how you calculated it in the yellow boxes
….. Someone is on the Gold Plan or prefers zumba classes? OR
….. Someone is on the Gold Plan or uses a trainer frequently?
c. What is the probability that (answer ONE of the three below depending on your pivot table)
….. Someone is on the Family plan and uses the racquet courts the most? OR ANSWER = < Do not just type in your final answer. Show me how you calculated it in the yellow boxes
….. Someone is on the Family plan and prefers pilates/yoga classes? OR
….. Someone is on the Family plan and uses a personal trainer often?
3. Describe two things you have learned from your data that would help your friend to market better to customers in various plans.
* If your pivot table compares the type of fitness plan against the fitness section used the most, you would answer the first question in each set.
* If your pivot table compares the type of fitness plan against the favorite type of class, you would answer the second question in each set.
* If your pivot table compares the type of fitness plan against the frequency of using a personal trainer, you would answer the third question in each set.
Put your pivot table below. NOTE: If you want to use the numbers in the pivot table to calculate probabilities, then I recommend that after you create the pivot table, that you also make a copy of the pivot table and paste the VALUES below or to the right of it and use that to set up formulas.

Binomial

Your friend would like some assistance in predicting equipment failures on several of his fitness machines. All the machines were purchased at the same time and have a constant probability of failure during their first year of service. He is trying to determine how many machines to purchase to ensure sufficient uptime for his clients. Please complete the following: 1. You already should have made a copy of the raw data sheet and placed a copy of the VALUES ONLY in the "My Data" worksheet, If you have not already done this, do so now. 2. In the My Data worksheet, locate the column labeled Binomial. Copy the numbers, then paste the VALUES in the blue boxes below (p, a, b, c, d). There should be NO formulas in the boxes. * 3. Calculate the probabilities below using Excel's BINOMIAL.DIST function. To get credit, make sure that you show your formulas in the boxes. 4. Calculate the probablities for all of the X values in the table to the right using Excel's BINOMIAL.DIST function.
Probability of a failure: p 0.00000 < do not enter a number here! x P(X)
Number of machines purchased = d 0 < do not enter a number here! 0 Make sure you type in your formulas in all yellow boxes to
What is the P(X=a)? Answer = 1 receive credit. Do not just paste a value. Show me how you got each number.
What is the P(X <= b)? Answer = 2
What is the P(X > c)? Answer = 3
Your # 4
Probability of a failure: p <-- NOTE: If the probability you get is > 1, subtract 1 and use that number instead 5
a = Example: If p = 1.256985, then enter 0.256985 6
b = 7
c = 8
d = 9 NOTE: Don't panic if the probability you get is #NUM after the maximum
10 number of machines purchased (d). That's expected as you can't have a
In the yellow boxes in column C, paste the VALUES from binomial column in the My Data sheet 11 probability for machines you don't buy.
Use your numbers to do the probability calculations above. 12
13
14
15
* If you see formulas in the blue boxes above, then you did not copy the values from the raw data sheet into the My Data worksheet as you should have.
Follow the instructions from the first data analysis project to copy only the values. If you do not use the values only,
then your numbers will keep changing on this page so you won't be able to do the calculations properly.

Poisson

Your friend has kept detailed records recording the number of arrivals to his spa per 15-minute period during peak time periods. Please complete the following: 1. You already should have made a copy of the raw data sheet and placed a copy of the VALUES ONLY in the "My Data" worksheet, If you have not already done this, do so now. 2. In the My Data worksheet, locate the column labeled Poisson. Copy the numbers, then paste the VALUES in the blue boxes below (p, a, b, c, d). There should be NO formulas in the boxes. * 3. Calculate the probabilities below using Excel's POISSON.DIST function. To get credit, make sure that you show your formulas in the boxes. 4. Calculate the probablities for all of the X values in the table to the right using Excel's POISSON.DIST function.
2) Mean Arrivals/15 min. 0.0000 < do not enter a number here! x P(X) 4)
2) What is the P(X=a)? 3) Answer = 0
2) What is the P(b < X ≤ c)? 3) Answer = 1
2) What is the P(X > d)? 3) Answer = 2
3
Your # 4
1) Mean = 5
1) a = 6
1) b = 7
1) c = 8
1) d= 9
10
In the yellow boxes above, paste the VALUES from Poisson column in the My Data sheet 11
Use your numbers to do the probability calculations above. 12
13
* If you see formulas, then you did not copy the values from the raw data sheet into the My Data worksheet as you should have. 14
Follow the instructions from the first data analysis project to copy only the values. If you do not use the values only, 15
then your numbers will keep changing on this page so you won't be able to do the calculations properly. 16
17
18
19
20
21
22
23
24
25
26
27
28
29
30

Normal

New members of the fitness club are offered a free fitness profile so they can better target what activities would be best given their fitness level, health profile, and fitness goals. Use your data to obtain the mean time each profile takes to complete as well as the standard deviation. Use this information then to answer the following questions: 1. Go to the output in the raw data sheet and locate the column labeled NORMAL. Copy the numbers, then paste the VALUES in the yellow boxes below (mean, a, b, c, d). 2. What is the probability that X < b? Put your formula in the yellow box shown for this question. HINT: Use the NORM.DIST function. 3. What is the probability that X > c? Put your formula in the yellow box shown for this question. HINT: Use the NORM.DIST function. 4. The top d% of new members take more than ____ minutes to complete their profile. HINT: Use the NORM.INV function.
Mean Time Taken for Profile 0.0000 < do not enter a number here! REMINDER: Always use the NORMAL.DIST function to calculate probabilities. For "cumulative",choose "TRUE".
Standard Deviation of time taken 0.0000 < do not enter a number here! This will give you the probability of being at a particular X value OR less (a cumulative probability).
What is the P(X < b)? Answer =
What is the P(X > c)? Answer =
Value of X representing top d% Answer =
Your #
Mean Time Taken for Profile
a = Standard Deviation of time
b =
c =
d =
In the yellow boxes directly above, paste the VALUES from normal column in My Data sheet
Use your numbers to do the probability calculations above.