Question

In: Statistics and Probability

An entrepreneur examines monthly sales (in $1,000s) for 40 convenience stores in Rhode Island. (You may...

An entrepreneur examines monthly sales (in $1,000s) for 40 convenience stores in Rhode Island. (You may find it useful to reference the appropriate table: z table or t table)

Excel data

Sales Sqft
140 1810
160 2500
80 1010
180 2170
140 2310
110 1320
90 1130
110 1500
130 1950
80 1010
110 1770
140 1840
140 2330
140 2490
120 1550
120 1900
210 2320
120 1700
180 2500
170 2380
160 1880
120 1780
120 1610
90 1230
140 1920
100 1260
90 1260
190 2470
130 2420
110 1550
100 1260
140 2230
100 1500
140 1970
120 1530
120 1800
110 1520
170 2210
100 1440
110 1470

a. Select the null and the alternative hypotheses in order to test whether average sales differ from $130,000.

  • H0: μ = 130,000; HA: μ ≠ 130,000

  • H0: μ ≥ 130,000; HA: μ < 130,000

  • H0: μ ≤ 130,000; HA: μ > 130,000

b-1. Calculate the value of the test statistic. (Negative value should be indicated by a minus sign. Round intermediate calculations to at least 4 decimal places and final answer to 3 decimal places.)

b-2. Find the p-value.

  • p-value < 0.01

  • 0.01 ≤ p-value < 0.02

  • 0.02 ≤ p-value < 0.05

  • 0.05 ≤ p-value < 0.10

  • p-value ≥ 0.10

c. At α = 0.05 what is your conclusion? Do average sales differ from $130,000?

  • Reject H0; average sales differ from $130,000.

  • Reject H0; average sales do not differ from $130,000.

  • Do not reject H0; average sales differ from $130,000.

  • Do not reject H0; average sales do not differ from $130,000.

Solutions

Expert Solution

Values ( X )
140000 138062500
160000 1008062500
80000 2328062500
180000 2678062500
140000 138062500
110000 333062500
90000 1463062500
110000 333062500
130000 3062500
80000 2328062500
110000 333062500
140000 138062500
140000 138062500
140000 138062500
120000 68062500
120000 68062500
210000 6683062500
120000 68062500
180000 2678062500
170000 1743062500
160000 1008062500
120000 68062500
120000 68062500
90000 1463062500
140000 138062500
100000 798062500
90000 1463062500
190000 3813062500
130000 3062500
110000 333062500
100000 798062500
140000 138062500
100000 798062500
140000 138062500
120000 68062500
120000 68062500
110000 333062500
170000 1743062500
100000 798062500
110000 333062500
Total 5130000 37177500000





To Test :-

H0: μ = 130,000

HA: μ ≠ 130,000

Test Statistic :-


t = -0.3585


Test Criteria :-
Reject null hypothesis if


Result :- Fail to reject null hypothesis

b-2. Find the p-value.

P value

Looking for the value t = 0.3585 across n - 1 = 40 - 1 = 39 degree of freedom for two tailed

t = 0.3585 lies between value 0.000 and 0.681 respective P value is 1.00 and 0.50

P value = 0.05 ≤ p-value < 0.10

c. At α = 0.05 what is your conclusion? Do average sales differ from $130,000

Do not reject H0

Average sales do not differ from $130,000.


Related Solutions

A. On May 29, 1790, by a mere 2 votes, Rhode Island ratified the US Constitution...
A. On May 29, 1790, by a mere 2 votes, Rhode Island ratified the US Constitution and completed the Union of the original 13 English colonies into the United States of America. Today more than 220 years later, the US is 50 States, additional commonwealths, and more than 320 million human lives. Generations of Americans have been born, lived, and died as the country has grown and matured. To what can we owe the longevity and strength of the United...
Suppose that you are an entrepreneur who has started a new chain of consumer electronics stores....
Suppose that you are an entrepreneur who has started a new chain of consumer electronics stores. Your competitive edge is to offer excellent customer service. What would you do to empower your employees to help achieve this goal? Write a 1 to 2 page paper on this subject and cite your resources
MM Co. predicts sales of $40,000 for May. MM Co. pays a sales manager a monthly...
MM Co. predicts sales of $40,000 for May. MM Co. pays a sales manager a monthly salary of $3,300 plus a commission of 7% of sales dollars. MM’s production manager recently found a way to reduce the amount of packaging MM uses. As a result, MM’s product will receive better placement on store shelves and thus May sales are predicted to increase by 9%. In addition, MM’s shipping costs are predicted to decrease from 5% of sales to 4% of...
You are planning to borrow OMR 3,500. You can repay the loan in 40 monthly payments...
You are planning to borrow OMR 3,500. You can repay the loan in 40 monthly payments of OMR 103.25 each or 36 monthly payments of OMR 112.94 each. You decide to take the 40-month loan. During each of the first 36 months you make the loan payment and place the difference between the two payments (OMR 9.69) into an investment account earning 10% APR. Beginning with the 37th payment you will withdraw money from the investment account to make your...
In ABC City, the average demand of SMART PHONES is 600 units. The May monthly index is 1.5. what is the seasonally adjusted sales forecast for May?
In ABC City, the average demand of SMART PHONES is 600 units. The May monthly index is 1.5. what is the seasonally adjusted sales forecast for May?A.1200 unitsB.400 unitsC.900 unitsD.No sufficient data to calculate
Nike had sales of $40 billion in 2019. Suppose you expect its sales to grow at...
Nike had sales of $40 billion in 2019. Suppose you expect its sales to grow at a rate of 4% forever. Based on Nike’s past profitability and investment needs, you expect EBIT to be 10% of sales, increases in net working capital requirements to be 12% of any increase in sales, and capital expenditures to equal depreciation expenses. Nike pays 22% income tax. The opportunity cost of capital is 10%. Nike has 0.9 billion shares outstanding, $3.3 billion in cash,...
4) Finally, you wish to determine if the mean monthly sales of the shirt in the...
4) Finally, you wish to determine if the mean monthly sales of the shirt in the superstores that comprise part of the chain in four regions of the country that you have defined differ from each other. Random samples of the sales of the item in stores chosen from each region are selected. The sample data comprising these sales figures is shown in appendix four below. At the 1% level of significance, are there any differences in the mean monthly...
4) Finally, you wish to determine if the mean monthly sales of the shirt in the...
4) Finally, you wish to determine if the mean monthly sales of the shirt in the superstores that comprise part of the chain in four regions of the country that you have defined differ from each other. Random samples of the sales of the item in stores chosen from each region are selected. The sample data comprising these sales figures is shown in appendix four below. At the 1% level of significance, are there any differences in the mean monthly...
Finally, you wish to determine if the mean monthly sales of the shirt in the superstores...
Finally, you wish to determine if the mean monthly sales of the shirt in the superstores that comprise part of the chain in four regions of the country that you have defined differ from each other. Random samples of the sales of the item in stores chosen from each region are selected. The sample data comprising these sales figures is shown in appendix four below. At the 1% level of significance, are there any differences in the mean monthly sales...
Overview In this assignment, you will write a program to track monthly sales data for a...
Overview In this assignment, you will write a program to track monthly sales data for a small company. Input Input for this program will come from two different disk files. Your program will read from these files by explicitly opening them. The seller file (sellers.txt) consists of an unknown number of records, each representing one sale. Records consist of a last name, a first name, a seller ID, and a sales total. So, for example, the first few records in...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT