Answered step by step
Verified Expert Solution
Link Copied!

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.

image text in transcribedimage text in transcribedimage text in transcribed
BLUE (g) 0.775 0.863 0.825 0.854 0.869 0.864 0.887 0.912 0.807 0.855 0.818 0.942 0.886 0.841 0.932 0.868 0.810 0.881 0.803 0.858 0.842 0.832 0.881EXAM SCORES 93 40 20 52 59 75 41 74 65 40 38 46 65 31 36 49 53 76 64 45 65 70 37HEIGHT (cm) 186.0 160.5 179.0 166.7 178.5 180.4 166.3 181.1 170.0 180.8 174.7 171.9 175.9 179.8 182.9 169.3 161.6 166.2 155.0 178.4 176.7 174.9 178.2

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Algebra And Trigonometry (Subscription)

Authors: Michael Sullivan

9th Edition

0321830741, 9780321830746

More Books

Students also viewed these Mathematics questions

Question

=+b) Is the trend term statistically significant?

Answered: 1 week ago

Question

Write short notes on Interviews.

Answered: 1 week ago

Question

Behaviour: What am I doing?

Answered: 1 week ago