Answered step by step
Verified Expert Solution
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
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 2Step 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