{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

Unit4_Excel_case_template(1)

# Unit4_Excel_case_template(1) - -30 85 120 Explain variance...

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

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

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

View Full Document
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

{[ snackBarMessage ]}

### What students are saying

• As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

Kiran Temple University Fox School of Business ‘17, Course Hero Intern

• I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

Dana University of Pennsylvania ‘17, Course Hero Intern

• The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

Jill Tulane University ‘16, Course Hero Intern