Question

In: Economics

1) The following data shows the yearly production data collected from firms in XYZ state and...

1) The following data shows the yearly production data collected from firms in XYZ state and ABC state.

Yearly production in tons

Number of Firms in XYZ

Number of Firms in ABC

50 - 150

9

35

150 - 250

10

40

250 - 350

11

56

350 - 450

40

62

450 - 550

56

78

550 - 650

68

55

650 - 750

110

53

750 - 850

125

52

850 - 950

98

44

950 - 1050

105

42

1050 -1150

25

48

1150 -1250

20

57

1250 -1350

18

40

1350 - 1450

5

38

1) Calculate:

  • the coefficient of variation for XYZ and ABC
  • the interquartile range for XYZ and ABC
  • the median for XYZ and ABC
  • the mode for XYZ and ABC
  • the variance for XYZ and ABC
  • mean deviation from the mean for XYZ and ABC

Solutions

Expert Solution

1) Coeeficient of variation is defined as standard deviation of the data divided by the sample mean.

Let us write down general formulae for standard deviation and mean:

For XYZ,

For ABC:

b) Interquartile range is defined as Quartile3-Quartile1, where quartile3 is the point upto which the 75% of ditribution has been covered and quartile1 is the point of 25% coverage.

Quartiles are found as below:

If the number of entries is even: 2n, then the first quartile Q1 is given by

Q1 = median of the n smallest entries

and Q3 = median of the n largest entries

If the number of entries is odd, 2n+1, then the first quartile Q1 is given by

Q1 = median of the n smallest entries

and Q3 = median of the n largest entries

Here we have even number of entries (14), so

XYZ ABC
Q3 90.5 55.75
Q1 12.75 40.5
IQR 77.75 15.25

c) For even numbers, median is the average of the middle two numbers when numbers are arranged in ascending order.

Median(XYZ)=32.5

Median(ABC)=50

d) Mode refers to the most frequent outcome.

For XYZ, mode= There is no mode, since each value appears once.

For ABC, mode= 40


Related Solutions

The following data shows the yearly production data collected from country A and B. Yearly profit...
The following data shows the yearly production data collected from country A and B. Yearly profit in ‘000 Calculate: 1) the coefficient of variation for firms in State A and B 2) the interquartile range for firms in State A and B 3) the median profit for firms in State A and B 4) the mode profit for firms in State A and B 5) the profit variance for firms in State A and B 6) mean deviation from the...
The following data were collected on the yearly registration for a six sigma seminar at the...
The following data were collected on the yearly registration for a six sigma seminar at the University of Malaya Tahun/Year Pendaftaran/ Registration 1 400 2 600 3 400 4 500 5 1000 6 800 7 700 8 900 9 1200 10 1400 a. Calculate a 3-year moving average to forecast registration from year 4 to year 11.
The following data shows the yearly income (in $1,000) and age of a sample of seven...
The following data shows the yearly income (in $1,000) and age of a sample of seven individuals. Income (in $1,000) (Y) Age (X) 20 18 24 20 24 23 25 34 26 24 27 27 34 27 SUMMARY OUTPUT Regression Statistics Multiple R $0.48 R Square $0.23 Adjusted R Square $0.07 Standard Error $4.11 Observations 7 ANOVA df SS MS F Significance F Regression 1 24.79 24.79 1.46 0.28 Residual 5 84.64 16.93 Total 6 109.43 Coefficients Standard Error t...
1. The following data shows memory scores collected from adults of different ages. Age (X) Memory...
1. The following data shows memory scores collected from adults of different ages. Age (X) Memory Score (Y) 25 10 32           10 39 9 48 9 56 7 Use the data to find the regression equation for predicting memory scores from age Group of answer choices a. Ŷ = 4.33X + 0.11 b. Ŷ = -0.11X + 4.33 c. Ŷ = -0.11X + 13.26 d. Ŷ = -0.09X + 5.4 e. Ŷ = -0.09X + 12.6 1a Use the regression...
The following data was collected by taking samples of size 10 from a production process at...
The following data was collected by taking samples of size 10 from a production process at Murray Manufacturing. The average weight and range are resented in the data below. Develop an X bar chart to determine if the production process is statistically in control and comment on any pattern, if present. Sample Sample Mean Range 1 11 1.5 2 12 1 3 14 2 4 11 .5 5 13 1 6 14 1 7 12 1.5 8 12 2 9...
Forecasting 1. Demand data collected on yearly registrations for a Six Sigma seminar at the Quality...
Forecasting 1. Demand data collected on yearly registrations for a Six Sigma seminar at the Quality College are shown in the following table Year 1 2 3 4 5 6 7 8 9 10 11 12 Registration 4000 6000 4000 5000 10000 8000 7000 9000 12000 14000 15000 a. Estimate (forecast) demand again for years 4-12 with a 3-year weighted moving average in which registrations in the most recent year are given a weight of 0.50, 0.25, and 0.25. b....
The following data is given for the XYZ Company:       Budgeted production                         &nbsp
The following data is given for the XYZ Company:       Budgeted production                                                          26,000 units       Actual production                                                               27,500 units       Materials:                                                                                  Standard price per ounce                                                 $6.50        Standard ounces per completed unit                                 8        Actual ounces purchased and used in production              228,000        Actual price paid for materials                                          $1,504,800       Labor:                                                                                        Standard hourly labor rate                                                $22 per hour        Standard hours allowed per completed unit                      6.6        Actual labor hours worked                                                183,000        Actual total labor costs                                                     $4,016,850...
1. Data collected on the yearly demand for 50-pound bags of fertilizer at Wallace Garden Supply...
1. Data collected on the yearly demand for 50-pound bags of fertilizer at Wallace Garden Supply are shown in the following table. Develop a three-year moving average to forecast sales. Then estimate demand again with a weighted moving average in which sales in the most recent year are giveo9n a weight of 2 and sales in the other two years are each given a weight of 1. Which method do you think is best? Year Demand for Fertilizer (1,000s of...
Data collected on the yearly registrations for a Six Sigma seminar at the Quality College are...
Data collected on the yearly registrations for a Six Sigma seminar at the Quality College are shown in the following​ table: Year 1 2 3 4 5 6 7 8 9 10 11 Registrations (000) 5.00 7.00 3.00 5.00 9.00 9.00 7.00 11.00 13.00 14.00 12.00 a. Calculate the forecasted registrations for years 2 through 12 using exponential smoothing, with a smoothing constant (α) of 0.40 and a starting forecast for 5.00 year 1 (round your responses to one demical...
Data collected on the yearly registrations for a Six Sigma seminar at the Quality College are...
Data collected on the yearly registrations for a Six Sigma seminar at the Quality College are shown in the following​ table:                                                                                                                                                              Year 1 2 3 4 5 6 7 8 9 10 11 Registrations​ (000) 4.00 5.00 4.00 4.00 9.00 9.00 6.00 9.00 11.00 16.00 12.00 ​a) Calculate the forecasted registrations for years 2 through 12 using exponential​ smoothing, with a smoothing constant ​(α​) of 0.30 and a starting forecast of 4.00 for year 1 ​(round your responses to...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT