Question

In: Statistics and Probability

(1 point) A national sporting good store wishes to use demographic information to predict its monthly...

(1 point) A national sporting good store wishes to use demographic information to predict its monthly sales, in $1000s. Thrity-eight, n=38n=38, stores of the chain are randomly chosen across the country. It is known that each store is approximately the same size and carries the same merchandise.

The geographic area from which a store draws its customers is known as the customer base. One of the variables is the percentage of the customer base who have graduated from high school.

MonthlySalesiMonthlySalesi = β0β0 + β1PercentHSGradsiβ1PercentHSGradsi + eiei

where

MonthlySalesiMonthlySalesi - is the total sales in month ii, in $1000s

PercentHSGradsiPercentHSGradsi - is percentage of all customers in store ii customer base that have graduated from high school

A least-squares regression was ran in R producing the following output:



Regression Analysis: MonthlySales versus PercentHSGrads

Predictor Coef SD Coef T P
Constant -2970 1371
PercentHSGrads 59.66 17.67


S = 802.004 R-Sq =

Analysis of Variance
Source DF SS MS F P
Regression 7333350
Residual Error 23155564
Total 37



Using the partial R output, answer the questions below.

(a) Estimate the model. Use two-decimals your estimation of the slope term, no decimals in the estimation of the y-intercept.


MonthlySalesiˆMonthlySalesi^ =

equation editor

Equation Editor

+

equation editor

Equation Editor

PercentHSGradsiPercentHSGradsi

(b) What percentage of the variation in a store's monthly sales cannot be explained by its linear dependency on the percentage of the customer base that are high school graduates? Enter your answer as a percentage, using two decimal places.

equation editor

Equation Editor

%


(c) Does the data collected indicate that the monthly sales of a store can be expressed as a linear function the percentage of high school graduates in its customer base? Select the correct statisticaly hypotheses.

A. H0:βˆ1≥0HA:βˆ1<0H0:β^1≥0HA:β^1<0
B. H0:β1=0HA:β1≠0H0:β1=0HA:β1≠0
C. H0:β1=0HA:β1<0H0:β1=0HA:β1<0
D. H0:βˆ1≥0HA:βˆ1≠0H0:β^1≥0HA:β^1≠0
E. H0:β1≥0HA:β1>0H0:β1≥0HA:β1>0
F. H0:βˆ1=0HA:βˆ1>0H0:β^1=0HA:β^1>0

(d) Using the FF-test, test the statistical hypotheses determined in (c). Find the value of the test statistic, using two decimals in your answer.

FcalcFcalc =

equation editor

Equation Editor




(e) Testing the statistical hypotheses in (c) at α=0.05α=0.05, you can conclude from this data that the  ? monthly sales of a store percentage of customer base that are high school graduates   ? can cannot  be expressed as a linear function of the  ? monthly sales of a store percentage of customer base that are high school graduates .


(f) Can you infer from this data that an increase of 1% to the percentage of high school graduates in the customer based will lead to an mean/average increase in the store's monthly sales by more than $50,000?


(i) Find the value of the test statistic, use two decimal places in your answer.

TcalcTcalc =

equation editor

Equation Editor




(ii) Find the PP-value of the result, using three decimals.

PP-value =

equation editor

Equation Editor




(g) A store located at a local mall has recently discovered that 90% of its customer base has a high school diploma. With 95% confidence, estimate this store's monthly sales for the current month.
Note: You will need ∑38i=1PercentHSGradsi=2935.17∑i=138PercentHSGradsi=2935.17 and ∑38i=1PercentHSGrads2i=228777∑i=138PercentHSGradsi2=228777


Lower Bound =

equation editor

Equation Editor

$1000s (use one decimal in your answer)

Upper Bound =

equation editor

Equation Editor

$1000s (use one decimal in your answer)

(h) A residual plot of the regression was consulted.



What does this residual plot say about the condition(s) of the model? Pick the most appropriate answer.

A. The variance in the monthly sales is not the same for all stores with different proportions of high school graduates in their respective customer base.
B. The variance in the monthly sales is the same for all stores with different proportions of high school graduates in their respective customer base.
C. The distribution in the monthly sales is Normally distributed.
D. The distribution in the monthly sales is not Normally distributed.
E. The variation in the proportion of the customer base that are high school graduates is the same for all stores.
F. The variation in the proportion of the customer based that are high school graduates is not the same for all stores.

COULD YOU ANSWER ONLY ON QUESTION H, G, E, F

Solutions

Expert Solution


Related Solutions

A sporting good store sells 100 pool tables per year. It costs $62 to store one...
A sporting good store sells 100 pool tables per year. It costs $62 to store one pool table for a year. To re-order, there is a fixed cost of $31 per shipment plus $16 for each pool table. How many times per year should the store order pool tables, and then what lot size, in order to minimize inventory costs? A sporting good store sells 100 pool tables per year. It costs $62 to store one pool table for a...
A local grocery store wants to predict the monthly sales in dollars. The manager believes that...
A local grocery store wants to predict the monthly sales in dollars. The manager believes that the amount of newspaper advertising significantly affects the store sales. The manager randomly selects 10 months of data consisting of monthly grocery store sales (in thousands of dollars) and advertising expenditures (in thousands of dollars). See the following data: If the advertising expenditures increase by one thousand of dollars, estimate the average increase in sales with 95% confidence. The next month, the grocery store...
A store gathers some demographic information from their customers. The following chart summarizes the age-related information...
A store gathers some demographic information from their customers. The following chart summarizes the age-related information they collected: Age Number of Customers <20<20 67 [20-29) 68 [30-39) 87 [40-49) 57 [50-59) 62 ≥60≥60 58 One customer is chosen at random for a prize giveaway. Enter your answers as either decimals or fractions, not as percents. What is the probability that the customer is at least 20 but less than 60?     (Round to 4 places) What is the probability that the...
A sporting goods store believes the average age of its customers is 35 or less. A...
A sporting goods store believes the average age of its customers is 35 or less. A random sample of 42 customers was​ surveyed, and the average customer age was found to be 39.2 years. Assume the standard deviation for customer age is 9.0 years. Using alphaαequals=0.10 complete parts a and b below. a. Does the sample provide enough evidence to refute the age claim made by the sporting goods​ store? Determine the null and alternative hypotheses. Upper H 0H0​: muμ...
1. Use the following information provided and the answers to the questions below to predict what...
1. Use the following information provided and the answers to the questions below to predict what the weighted average cost of capital might be in the future. Then, use the WACC to make an informed decision about whether or not the company should invest in a new project. Publicly traded companies are required to produce annual accounting reports (10-K) for the SEC detailing the financial operations of the past year. Suppose that you look up a company and find that...
2. A large sporting goods store is placing an order for bicycles with its supplier. Four...
2. A large sporting goods store is placing an order for bicycles with its supplier. Four models can be ordered: the adult Open Trail, the adult Cityscape, the girl's Sea Sprite, and the boy's Trail Blazer. It is assumed that every bike ordered will be sold, and their profits, respectively, are 30, 25, 22, and 20. The LP model should maximize profit. There are several conditions that the store needs to worry about. One of these is space to hold...
A large sporting goods store is placing an order for bicycles with its supplier. Four models...
A large sporting goods store is placing an order for bicycles with its supplier. Four models can be ordered: the adult Open Trail, the adult Cityscape, the girl's Sea Sprite, and the boy's Trail Blazer. It is assumed that every bike ordered will be sold, and their profits, respectively, are 30, 25, 22, and 20. There are several conditions that the store needs to worry about. One of these is space to hold the inventory. An adult's bike needs two...
A large sporting goods store is placing an order for bicycles with its supplier. Four models...
A large sporting goods store is placing an order for bicycles with its supplier. Four models can be ordered: the adult Open Trail, the adult Cityscape, the girl's Sea Sprite, and the boy's Trail Blazer. It is assumed that every bike ordered will be sold, and their profits, respectively, are 30, 25, 22, and 20. The LP model should maximize profit. There are several conditions that the store needs to worry about. One of these is space to hold the...
Use the following information for questions in Problem 3: After reading a demographic study on the...
Use the following information for questions in Problem 3: After reading a demographic study on the habits and modern lifestyles of the American public, TI Inc. decided launching a new product, Gizmo ™. TI’s CEO has asked you to determine whether or not to go ahead with the introduction of a new product. You have the following information: • Most of the numbers for your estimates come from a study by marketing consultant that you received two months ago. The...
USE THE INFORMATION BELOW FOR PROBLEMS 1-4 An analyst wishes to estimate the share price for...
USE THE INFORMATION BELOW FOR PROBLEMS 1-4 An analyst wishes to estimate the share price for Ashley Corporation. The following information is made available: Estimated profit margin = 15% Total asset turnover = 2 Financial leverage = 1.2 Estimated dividend payout ratio = 75% Required rate of return = 14% Estimated EPS = $2.50 1. Calculate the firm's ROE. 2. Calculate the firm's sustainable growth rate. 3. Calculate the firm’s P/E multiple. 4. Calculate the firm’s estimated share price. USE...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT