Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Determine the mean and standard deviation values from the data below. Calculate the % of each data set that falls within 1, 2 and 3
Determine the mean and standard deviation values from the data below. Calculate the % of each data set that falls within 1, 2 and 3 standard deviations. The count and countifs functions will be useful.Make a table that summarizes the findings, then provide a comment on the results. Do the fractions of data that fall within the various standard deviation ranges agree with what you would expect for a normally distributed random variable? Are there any datasets where the ranges seem odd?Use Excel.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started