Unit4_Excel_case_template(1)

Unit4_Excel_case_template(1) - -30 900 55 75 85 120 Explain...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
Name:  You are free to use this speadsheet template or one of your own that you've created.  Part I Mean =  35 35 35 35 Median 35 35 35 35 Mode =  fill in the above table for mean, median, and mode and solve.  Mean =  ? Median =  ? Mode =  ? Explain mean, median, and mode in practical terms for some partial credit. Part II Explain Breakeven:  1st month 2nd month 770 X 1.1 equals 8.47 $847.00  8.47 X 1.1  ??? Explain Breakeven and why it's important to a business Part III fill in the table below and solve for sum of squares, variance, standard deviation. Values Deviation Square of Deviation 35 35-65
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 2
Background image of page 3
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: -30 900 55 75 85 120 Explain variance and standard deviation in practical terms for some partical credit. hint: find the mean first, which will be used for the deviation Variance equals: Sum of Square Dev divided by (n-1) equals ___ Standard Dev equals _______ Explain your findings. Example, there are only 8 data points between 35.5 and 94.5 or only 50 35 55 35 55 3rd month ???? . # Occurrences Total 6 5400 Sum of Square Dev = ____ 0% within one standard deviation. This would suggest that this is not a normal distribution of sales s...
View Full Document

This note was uploaded on 05/16/2011 for the course BUS 250 taught by Professor Barrie during the Spring '10 term at Kaplan University.

Page1 / 3

Unit4_Excel_case_template(1) - -30 900 55 75 85 120 Explain...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online