Question

In: Economics

Sales Data provides data on a sample of customers. An industry trade publication stated that the...

Sales Data provides data on a sample of customers. An industry trade publication stated that the average profit per customer for this industry was at least $4,500. Using a test of hypothesis, do the data support this claim or not?

Customer Percent Gross Profit Gross Sales Gross Profit Industry Code Competitive Rating*
1 51.0% $170.00 $86.70 1 2
2 32.0% $181.00 $57.92 3 4
3 20.0% $203.00 $40.60 2 2
4 22.0% $249.00 $54.78 5 1
5 21.0% $476.00 $99.96 5 1
6 21.0% $476.00 $99.96 5 4
7 22.0% $635.00 $139.70 2 3
8 34.0% $856.00 $291.04 3 3
9 26.0% $1,062.00 $276.12 4 2
10 16.6% $1,110.00 $183.71 7 3
11 20.0% $1,153.00 $230.60 7 3
12 36.0% $1,392.00 $501.12 4 2
13 18.0% $1,743.00 $313.74 4 2
14 20.0% $2,307.00 $461.40 7 3
15 5.0% $2,534.00 $126.70 4 5
16 29.0% $2,683.00 $778.07 7 2
17 10.0% $2,780.00 $278.00 2 3
18 37.0% $3,272.00 $1,210.64 5 3
19 60.0% $3,864.00 $2,318.40 7 1
20 24.0% $3,988.00 $957.12 6 3
21 9.0% $4,072.00 $366.48 7 3
22 50.0% $4,190.00 $2,095.00 5 3
23 17.0% $4,219.00 $717.23 3 4
24 32.0% $4,711.00 $1,507.52 7 1
25 15.0% $4,824.00 $723.60 6 3
26 10.0% $4,878.00 $487.80 7 4
27 13.0% $5,157.00 $670.41 7 2
28 22.0% $5,552.00 $1,221.44 2 3
29 17.0% $5,876.00 $998.92 1 3
30 19.0% $5,888.00 $1,118.72 6 4
31 6.0% $7,632.00 $457.92 5 4
32 23.0% $8,058.00 $1,853.34 3 3
33 23.0% $12,056.00 $2,772.88 7 2
34 14.0% $12,981.00 $1,817.34 2 4
35 22.0% $13,406.00 $2,949.32 2 3
36 14.0% $15,882.00 $2,223.48 7 3
37 28.0% $16,343.00 $4,576.04 3 3
38 27.0% $19,985.00 $5,395.95 5 3
39 3.0% $20,160.00 $604.80 5 5
40 46.0% $26,616.00 $12,243.36 5 2
41 26.0% $28,018.00 $7,284.68 5 3
42 11.0% $28,950.00 $3,184.50 4 4
43 18.0% $29,646.00 $5,336.28 4 3
44 37.0% $31,019.00 $11,477.03 6 1
45 20.0% $31,305.00 $6,261.00 2 3
46 21.0% $34,769.00 $7,301.49 7 1
47 10.0% $34,817.00 $3,481.70 4 3
48 14.0% $38,609.00 $5,405.26 1 3
49 9.0% $38,923.00 $3,503.07 2 5
50 16.0% $40,536.00 $6,485.76 4 3
51 22.0% $54,851.00 $12,067.22 6 2
52 21.0% $54,861.00 $11,520.81 7 2
53 17.0% $58,063.00 $9,870.71 5 4
54 11.0% $62,862.00 $6,914.82 4 5
55 7.0% $78,574.00 $5,500.18 3 5
56 14.0% $92,776.00 $12,988.64 4 3
57 15.0% $112,837.00 $16,925.55 1 4
58 13.0% $115,999.00 $15,079.87 4 5
59 21.0% $120,854.00 $25,379.34 5 4
60 14.0% $179,101.00 $25,074.14 6 3
*Rates the amount of competition for sales of the products sold to these customers: 1 = very little competition to 5 = very competitive

Solutions

Expert Solution

Gross Profits
1   86.70
2   57.92
3   40.60
4   54.78
5   99.96
6   99.96
7 139.70
8   291.04
9   276.12
10   183.71
11   230.60
12   501.12
13   313.74
14   461.4
15   126.7
16   778.07
17   278
18   1,210.64
19   2,318.40
20   957.12
21   366.48
22   2,095.00
23   717.23
24   1,507.52
25   723.6
26   487.8
27   670.41
28   1,221.44
29   998.92
30   1,118.72
31   457.92
32   1,853.34
33   2,772.88
34   1,817.34
35   2,949.32
36   2,223.48
37   4,576.04
38   5,395.95
39   604.80
40   12,243.36
41   7,284.68
42   3,184.50
43   5,336.28
44   11,477.03
45   6,261.00
46   7,301.49
47   3,481.70
48   5,405.26
49   3,503.07
50   6,485.76
51   12,067.22
52   11,520.81
53   9,870.71
54   6,914.82
55
5,500.18
56   12,988.64
57   16,925.55
58   15,079.87
59   25,379.34
60   25,074.14
  4239.16467 Mean
  5811.7292 Standard deviation

The t-test statistic will be used as shown below:

We set,

H0: 4500

HA: 4500

tstatistic= x - [/ (S/n)]

tstatistic= 4239.16467 - [4500 / (5811.7292 / 60)]

tstatistic= - 0.3476

The critical value comes out to be 1.67

Thus, the null hypothesis is rejected.


Related Solutions

Research of the intra-industry trade contents the trade volume, value, industries, trends, comparison with inter-industry trade...
Research of the intra-industry trade contents the trade volume, value, industries, trends, comparison with inter-industry trade of exact two countries and some other related issues about Myanmar and China
The Excel file Store and Regional Sales Database provides sales data for computers and peripherals showing...
The Excel file Store and Regional Sales Database provides sales data for computers and peripherals showing the store identification number, sales region, item number, item description, unit price, units sold, and month when the sales were made during the fourth quarter of last year.3 Modify the spreadsheet to calculate the total sales revenue for each of the eight stores as well as each of the three sales regions.
The simple linear regression of the data on $Sales and number of customers produced the following...
The simple linear regression of the data on $Sales and number of customers produced the following ANOVA output: ANOVA Source df SS MS F Significance F Regression 46833541 Residual Total 51360495 Complete as much of the ANOVA table as you need to answer the following two questions (Questions 18 and 19): The calculated value of the test statistic used to test the following null and alternative hypotheses Ho: The overall regression model is not significant Ha: The overall regression model...
The data below represents the amount that a sample of fifteen customers spent for lunch ($)...
The data below represents the amount that a sample of fifteen customers spent for lunch ($) at a fast-food restaurant: 8.42   6.29   6.83   6.50   8.34   9.51   7.10   6.80   5.90   4.89   6.50   5.52   7.90   8.30   9.60 At the 0.01 level of significance, is there evidence that the mean amount spent for lunch is different from $6.50? Follow and show the 7 steps for hypothesis testing.   Determine the p-value and interpret its meaning. What assumption must you make about the population distribution...
Taking the family to an amusement park has become increasingly costly according to the industry publication...
Taking the family to an amusement park has become increasingly costly according to the industry publication Amusement Business, which provides figures on the cost for a family of four to spend the day at one of America’s amusement parks. A random sample of 25 families of four that attended amusement parks yielded the following costs, rounded to the nearest dollar. 122 166 171 148 135 173 137 163 119 144 164 153 162 140 142 158 130 167 173 186...
% - XYZ Company provides you with the following data projected for 2018: Projected sales are...
% - XYZ Company provides you with the following data projected for 2018: Projected sales are 30,000 units. Inventory at Dec 31,2017 was 4,000 manufactured units. The desired ending for Dec 31, 2018 is 8,000 manufactured units. a) 5% - Provide a production budget for the number of units that need to be produced. b) 6% - Assume for each unit manufactured, four pounds of raw materials are needed. Assume the desired ending inventory became 10,000 manufactured units. What effect...
The following data set provides information on the lottery sales, proceeds, and prizes by year in...
The following data set provides information on the lottery sales, proceeds, and prizes by year in Iowa. FYI Sales Proceeds Prizes 1986 $85,031,584 $27,631,613 $39,269,612 1987 $98,292,366 $31,157,797 $47,255,945 1988 $128,948,560 $40,090,157 $65,820,798 1989 $172,488,594 $49,183,227 $92,563,898 1990 $168,346,888 $50,535,644 $90,818,207 1991 $158,081,953 $44,053,446 $86,382,329 1992 $166,311,122 $45,678,558 $92,939,035 1993 $207,192,724 $56,092,638 $116,820,274 1994 $206,941,796 $56,654,308 $116,502,450 1995 $207,648,303 $58,159,175 $112,563,375 1996 $190,004,182 $51,337,907 $102,820,278 1997 $173,655,030 $43,282,909 $96,897,120 1998 $173,876,206 $42,947,928 $96,374,445 1999 $184,065,581 $45,782,809 $101,981,094 2000 $178,205,366 $44,769,519...
The following data set provides information on the lottery sales, proceeds, and prizes by year in...
The following data set provides information on the lottery sales, proceeds, and prizes by year in Iowa. FY Sales Proceeds Prizes 1992 $166,311,122 $45,678,558 $92,939,035 1993 $207,192,724 $56,092,638 $116,820,274 1994 $206,941,796 $56,654,308 $116,502,450 1995 $207,648,303 $58,159,175 $112,563,375 1996 $190,004,182 $51,337,907 $102,820,278 1997 $173,655,030 $43,282,909 $96,897,120 1998 $173,876,206 $42,947,928 $96,374,445 1999 $184,065,581 $45,782,809 $101,981,094 2000 $178,205,366 $44,769,519 $98,392,253 2001 $174,943,317 $44,250,798 $96,712,105 2002 $181,305,805 $48,165,186 $99,996,233 HelpCopy to ClipboardDownload CSV Create a graph using the sales and year. What approximate range...
The following data set provides information on the lottery sales, proceeds, and prizes by year in...
The following data set provides information on the lottery sales, proceeds, and prizes by year in Iowa. FY Sales Proceeds Prizes 1992 $166,311,122 $45,678,558 $92,939,035 1993 $207,192,724 $56,092,638 $116,820,274 1994 $206,941,796 $56,654,308 $116,502,450 1995 $207,648,303 $58,159,175 $112,563,375 1996 $190,004,182 $51,337,907 $102,820,278 1997 $173,655,030 $43,282,909 $96,897,120 1998 $173,876,206 $42,947,928 $96,374,445 1999 $184,065,581 $45,782,809 $101,981,094 2000 $178,205,366 $44,769,519 $98,392,253 2001 $174,943,317 $44,250,798 $96,712,105 2002 $181,305,805 $48,165,186 $99,996,233 HelpCopy to ClipboardDownload CSV Create a graph using the sales and year. What approximate range...
The data table below contains the amounts that a sample of nine customers spent for lunch​...
The data table below contains the amounts that a sample of nine customers spent for lunch​ (in dollars) at a​ fast-food restaurant 4.23 5.08 5.96 6.45 7.43 7.54 8.36 8.51 9.76 a) At the 0.05level of​ significance, is there evidence that the mean amount spent for lunch is different from ​$6.50​? b) Calculate test stastics ( four decimals places) C) Calculate P value and explain interpretations ( four decimal places)? d) Because the sample size is​ 9, do you need...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT