Class notes.xlsx - Data 12 14 15 12 14 12 14 15 12 14 Min Value of Quatrile Q1 Q2 Q3 Max Value of Quatrile Correlation=sigma/mean Column1 Mean 13.4

Class notes.xlsx - Data 12 14 15 12 14 12 14 15 12 14 Min...

This preview shows page 1 - 9 out of 26 pages.

Data 12 Column1 14 15 Mean 13.4 12 Standard Error 0.4 14 Median 14 12 Mode 12 14 Standard Deviation 1.264911 15 Sample Variance 1.6 12 Kurtosis -1.86756 14 Skewness -0.131762 Range 3 Minimum 12 Maximum 15 Sum 134 Count 10 Min. Value of Quatrile 12 Q1 12 Q2 14 Q3 14 Max. Value of Quatrile 15 Correlation=sigma/mean 9.44%
Image of page 1

Subscribe to view the full document.

Image of page 2
To compute the data, go to data analysis under data tab->Select data analysis->Select descriptive statistics-> CLASS WIDTH Class (in $1000s) Frequency 300 up to 400 4/36 = 0.11 0.11 400 up to 500 11/36 = 0.31 500 up to 600 14/36 = 0.39 600 up to 700 5/36 = 0.14 700 up to 800 2/36 = 0.06 Total 1 Relative Frequency Cumulative Relative Frequency 0.11 + 0.31 = 0.42 0.11 + 0.31 + 0.39 = 0.81 0.11 + 0.31 + 0.39 + 0.14 = 0.95 0.11 + 0.31 + 0.39 + 0.14 + 0.06 » 1.0 Largest value Smallest value Number of classes
Image of page 3

Subscribe to view the full document.

ü Positively skewed - data form a long, narrow tail to the right.
Image of page 4
>Select input range, only numerical values
Image of page 5

Subscribe to view the full document.

Image of page 6
n=5 p=0.25 a x=5 0.000977 Binom.dst(x,n,p,T/F) b X greater than equal to 4 means x=4 +x=5 0.000977 0.014648 0.015625 OR 1-X less than equal to 3 0.984375 0.015625 c x=0 0.237305 d x is less than or equal to two 0.896484
Image of page 7

Subscribe to view the full document.

How to create a pie chart? Weather Frequency Relative frequency Percentage Rainy 20 0.714285714285714 71% Sunny 7 0.25 25% Cloudy 1 0.035714285714286 4% Total 28 1 100% So when we create a pie chart, we need to select the first two columns, like here we selected weather and frequ Only the conents and not the headings. How to create a bar chart? Insert-> Recommended chart->column->Clustered column Note: When frequency distribution is repesented in tabular form, we need to represent it in the form o Fn+F4 is to freeze or select a cell Class (in$1000s) Frequency Cumulative frequency Relative cumulative Frequency 300-400 4 4 14.286% 400-500 11 15 53.571% 500-600 14 29 103.571% 600-700 5 34 121.429% 700-800 2 36 128.571% Total 36 Note: When frequency distribution is repesented in continuous form, we need to represent it in the fo How to create Histogram?
Image of page 8
Image of page 9
  • Winter '18

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

Ask Expert Tutors You can ask You can ask ( soon) You can ask (will expire )
Answers in as fast as 15 minutes