Probability and Statistical Analysis Worksheet
Complete
Parts A, and B.
Part A
1. Jake needs to score in the top 10% in order to earn a physical fitness certificate. The class mean is 78 and the standard deviation is 5.5. What raw score does he need?
Part B
The questions in Part B require that you access data from the Pulse Rate Dataset.
The data is based on the following research problem:
Ann conducted a study on the things that may affect pulse rate after exercising. She wants to describe the demographic characteristics of a sample of 55 individuals who completed a large-scale survey. She has demographic data on the participants’ gender (two categories), their age (open ended), their level of exercise (three categories), their height (open ended), and their weight (open ended).
2. Using Microsoft®
Excel®
software, run descriptive statistics on the gender and level of exercise variables. From the output, identify the following:
a. Percent of men
b. Mode for exercise frequency
c. Frequency of high level exercisers (exercise level 1) in the sample
3. Using Microsoft®
Excel®
software, run descriptive statistics to summarize the data on the age variable, noting the mean and standard deviation. Copy and paste the output from Microsoft®
Excel®
into this worksheet.
Title ABC/123 Version X 1 1 Probability and Statistical Analysis Worksheet Complete Parts A, and B. Part A 1. Jake needs to score in the top 10% in order to earn a physical fitness certificate. The class mean is 78 and the standard deviation is 5.5. What raw score does he need? Part B The questions in Part B require that you access data from the Pulse Rate Dataset. The data is based on the following research problem: Ann conducted a study on the things that may affect pulse rate after exercising. She wants to describe the demographic characteristics of a sample of 55 individuals who completed a large-scale survey. She has demographic data on the participants’ gender (two categories), their age (open ended), their level of exercise (three categories), their height (open ended), and their weight (open ended). 2. Using Microsoft® Excel® software, run descriptive statistics on the gender and level of exercise variables. From the output, identify the following: a. Percent of men b. Mode for exercise frequency c. Frequency of high level exercisers (exercise level 1) in the sample 3. Using Microsoft® Excel® software, run descriptive statistics to summarize the data on the age variable, noting the mean and standard deviation. Copy and paste the output from Microsoft® Excel® into this worksheet. Copyright © XXXX by University of Phoenix. All rights reserved.