Copy of BUS-352-RS-Homework_Ch3_Template

Color Key Insert your data Calculate/Identify The Answer Data Analysis Auto Calculated Auto Calculated Decision 4. Enter the cell range. 5. Check the Summary Statistics box. 6. Click OK

Output House Prices Mean 600000 Standard Error 357770.88 Median 300000 Mode 100000 Standard Deviation 800000 Sample Variance 6.4E+11 Kurtosis 4.130127 Skewness 2.0068359 Range 1900000 Minimum 100000 Maximum 2000000 Sum 3000000 Count 5 Confidence Level(95.0%) 993331.2

) RTILE.EXC(range,1) ange) RTILE.EXC(range,3) ) Data. Data Analysis. Descriptive Statistics ck OK.

Enter values below 52 55 71 59 Enter Descriptive Statistics here --> Row1 What is the Mean, Median, & Mode? Mean 59.45455 Standard Error 2.137814 Median 57 Mode 52 Standard Deviation 7.090326 Sample Variance 50.27273 Kurtosis -1.179807 Skewness 0.578941 Range 19 Minimum 52 Maximum 71 Sum 654 Count 11 Confidence Level(95.0%) 4.763346

62 57 52 69 57 68 52

February 33.0 January March 34.0 February April 34.0 March May 32.0 April June 32.0 May July 35.0 June August 34.0 July September 37.0 August October 37.0 September November 35.0 October December 33.0 a. Create previous year Descriptive Statistic below b. Create current year Descripti Mean 34.18181818 Mean Standard Error 0.51905827 Standard Error Median 34 Median Mode 34 Mode Standard Deviation 1.721521526 Standard Deviation Sample Variance 2.963636364 Sample Variance Kurtosis -0.487159221 Kurtosis Skewness 0.52148666 Skewness Range 5 Range Minimum 32 Minimum Maximum 37 Maximum Sum 376 Sum Count 11 Count Confidence Level(95.0%) 1.156533898 Confidence Level(95.0%) c. Previous Year Quartiles d. Current Year Quartiles 33 35 Month (previous year) Downloads (thousands) Month (current year) Downloads (thousands) Downloads (thousands) First Quartile =QUARTILE.EXC(range,1) First Quartile =QUARTILE.EXC(range,1) Third Quartile =QUARTILE.EXC(range,3) Third Quartile =QUARTILE.EXC(range,3)

37.0 37.0 37.0 38.0 37.0 36.0 37.0 35.0 33.0 32.0 ive Statistic below 35.9 0.622718056 37 37 1.969207398 3.877777778 0.443134997 -1.246265238 6 32 38 359 10 1.408686112 34.5 37 Downloads (thousands)

The five-number summary consists of what five statistical measures? a. min, Q 1 , mean, Q 3 , max b. min, Q 1 , median, Q 3 , max c. Q 1 , Q 2 , mean, Q 3 , Q 4 d. Q 1 , Q 2 , median, Q 3 , Q 4

Enter values below 2018 Season: 75 79 80 78 76 74 2019 Season: 72 71 76 78 86 81 2018 77 2.070197 2019 77 5.264436 Compute the Mean =AVERAGE(range) Compute the standard deviation. =STDEV.S(range) Compute the Mean =AVERAGE(range) Compute the standard deviation. =STDEV.S(range)

10 20 12 17 16 15 4 Observed Value (x) z-score Formulas 10 -1.25 20 1.25 12 -0.75 17 0.50 16 0.25 Compute the Mean =AVERAGE(range) Compute the standard deviation. =STDEV.S(range) Use either formula =(A12-$B$7)/$B$9 or =STANDARDIZE(x,mean,s)

Do a Descriptive Statistics =>

the mean. the mean. the mean. The cost (is/is not) is an outlier. n outlier. Use absolute z-score values. is structure be considered an outlier? Explain.

Enter values below 5 15 18 10 8 12 5 number summary 5 7 10 15.5 18 Insert Box Plot below Smallest =MIN(range) First Quartile =QUARTILE.EXC(range,1) Median =MEDIAN(range) Third Quartile =QUARTILE.EXC(range,3) Largest =MAX(B2:J2) This chart isn't available in your version of Excel. Editing this shape or saving this workbook into a different file format will permanently break the chart.