Answered

Find the best solutions to your questions at Westonci.ca, the premier Q&A platform with a community of knowledgeable experts. Join our Q&A platform to get precise answers from experts in diverse fields and enhance your understanding. Discover detailed answers to your questions from a wide network of experts on our comprehensive Q&A platform.

A statistics professor gives a survey to each of the 20 students in an introductory statistics course. The survey asks the students to estimate when they typically wake up on weekdays. The data are recorded in terms of the number of hours after midnight the students wake up. The data are included below. Use Excel to calculate the population standard deviation and the population variance.


Round your answers to three decimal places.




Wake up time

7.5

7.5

7.5

7.5

7.5

7

7

7

7

7

7

7

6.5

6.5

6.5

6

6

6.7

6.5

6.5

Sagot :

MrRoyal

Answer:

[tex]B2 = 0.465[/tex] --- Population standard deviation

[tex]C2 = 0.216[/tex] --- Population Variance

Step-by-step explanation:

Given: Wake-up time data

Required: Determine the population standard deviation and the population variance using Excel

First, enter the given data in Excel

For this question, I entered the data in cell A2 through cell A21

Cell B2 and Cell C2 were used to hold the results of the population standard deviation and the population variance, respectively.

In cell B2, the formula to use is:

=ROUNDUP(STDEV.P(A2:A21),3)

The round function rounds the result to 3 decimal places while STDEV.P calculates the population standard deviation.

So, the result is:

[tex]B2 = 0.465[/tex]

In cell C2, the formula to use is:

=ROUND(VAR.P(A2:A21),3)

The round function rounds the result to 3 decimal places while VAR.P calculates the population variance.

So, the result is:

[tex]C2 = 0.216[/tex]

See attachment for Excel file

View image MrRoyal
Thank you for visiting. Our goal is to provide the most accurate answers for all your informational needs. Come back soon. Thanks for stopping by. We strive to provide the best answers for all your questions. See you again soon. Thank you for choosing Westonci.ca as your information source. We look forward to your next visit.