Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Looking for some assistance with the highlighted part. How am I able to calulate both the frequency of values using the mean and standard deviation

Looking for some assistance with the highlighted part. How am I able to calulate both the frequency of values using the mean and standard deviation (Highlighted portion of the question) and also how then am i able to output the percentages in the range. (under the % bin shown at the bottom). Any assistance would be appreciated image text in transcribed

Evaluate the applicability of the Empirical Rule . Use Excel functions to calculate the mean, median and standard deviation of the dat:a o o Using the mean and standard deviation, find the frequency of values for each range of the empirical rule.These ranges are 8 Calculate the percentage of values that fall in the above ranges. Does the data fit the Empirical Rule? What does this result tell us? o 101 348 min max Bucket Class Frequency 125 100-125 150 125-150 75 150-175 200 175-200 225 200-225 250 225-250 275 250-275 00 275-300 325 300-325 350 325-350 18 15 10 10 13 9 100-125 125-150 150-175 175-200 200-225 225-250 250-275 275-300 300-325 325-350 average 227.9543 median st. dev. 60.80427 227 avg t s avg 2s avg t 3s 236 74.921 311 98.73 315 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_2

Step: 3

blur-text-image_3

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

Database Design And Implementation

Authors: Edward Sciore

2nd Edition

3030338355, 978-3030338350

More Books

Students also viewed these Databases questions

Question

4. How do our cultural spaces affect our identities?

Answered: 1 week ago