{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

Unit4_Excel_case_template(1)

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

Info icon This 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
Image of page 1

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

View Full Document Right Arrow Icon
Image of page 2
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

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    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.

    Student Picture

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

  • Left Quote Icon

    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.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    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.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern