Question: using an excel table using the 12 data available find the following sample statistics (Mean, Standard deviation, Variance, Median, Max, Min, Range , Q1, Q2,

using an excel table using the 12 data available find the following sample statistics (Mean, Standard deviation, Variance, Median, Max, Min, Range , Q1, Q2, Q3)

Jan ) 250.8

Feb-) 188.4

March ) 190.4

April ) 192.6

May) 220

June ) 186.4

July) 192.8

August) 190.8

Sept) 190

Oct) 188.6

Nov) 190.4

Dec) 193.6

***please values should be done on an excel sheet.. an example is attached as a picture to help the writer

using an excel table using the 12 data available find the following

SAMPLE Data Sample Statistics 90.68 May 20 mean 156.8433 197.08 June 20 standard deviation 84.50752 386.45 July 20 variance 7141.522 151.53 Aug 20 median 131.995 117.06 Sept 20 max 386.45 114.82 Oct 20 min 88.03 139.69 Nov 20 range 298.42 146.08 Dec 20 Q1 * 97.6 234.54 Jan 21 Q2* 131.995 124.3 Feb 21 Q3 * 185.6925 88.03 Mar 21 n 12 91.86 Apr 21

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!

using an excel table using the 12 data available find the following sample statistics (Mean, Standard deviation, Variance, Median, Max, Min, Range , Q1, Q2, Q3) Jan ) 250.8 Feb-) 188.4 March ) 190.4...

Total Gross 350,12 6,372 337,13 5,885 333,17 6,600 259,76 6,572 257,76 0,692 255,11 9,788 245,43 9,076 241,41 0,378 233,92 1,534 222,52 7,828 208,54 5,589 202,85 3,933 200,67 6,069 191,71 9,337...

Instructions: Complete the following problems within the MS Excel File. You should show process steps where applicable to receive credit. Include your Last Name and ID in each tab page. Submit your...

SUMMARY this journal, the length of it should not be more than 2 pages, with 1.5 spacing size 12 Times New Rome. Available online at www.sciencedirect.com Journal of Empirical Finance 15 (2008) 199 -...

STATISTICS FOR BUSINESS Matt Bognar 2016 Department of Statistics and Actuarial Science ii Statistics for Business, University of Iowa, 2016 Matt Bognar Contents 1 Statistical Graphics and Summary...

Hello! | need help with this statistics project that requires difference between two means. | have parts of it done however, need some help for rest. Data: - Original data included males and females...

1.Find a survey that analyzes value of a statistical variable. 2. Construct a histogram for your survey's numerical data using Excel. Make sure that your histogram has an appropriate width for the...

Question 2 30 marks This question is based on your work on MU123 up to and including Unit 4. An IT company develops software for the nancial services industry. It tests its code using an industry...

Question You are CMO (Chief Marketing Officer) for a large restaurant chain. In order to understand your competitors in a certain market, you seek to compare their prices for what you consider a...

Rank the following dienes in order of increasing reactivity in a Diels-Alder reaction (1 = least reactive, 4 = most reactive). Briefly explain your ranking.

Why does the antibody titer rise after infection? Is a high antibody titer indicative of an ongoing infection? Explain. Why is it necessary to obtain an acute and a convalescent blood sample to...

How to solve The production process is complicated by quality problems, requiring the production manager to expedite production and dispose of scrap. Required: Classify the activities into...

WHAT IS the cash flow statement BBINFIT ,AND HOW WE CAN ANALAYSES

=+ a. What happens to the labor demand curve?

=+to work more, because the reward for working an additional hour has risen (equivalently, the opportunity cost of leisure has gone up). Apply these concepts to Blanchards hypothesis about

=+ b. How would this change in productivity affect the labor marketthat is, employment, unemployment, and real wagesif the labor market is always in equilibrium?