# Question: Can demographic information be helpful in predicting sales at sp

Can demographic information be helpful in predicting sales at sporting goods stores? The data at left are monthly sales totals from a random sample of 38 stores in a large chain of nationwide sporting goods stores. All stores in the franchise, and thus within the sample, are approximately the same size and carry the same merchandise. The county, or in some cases counties, in which the store draws the majority of its customers is referred to here as the customer base. For each of the 38 stores, demographic information about the customer base is provided. The variables in the data set are:

Sales - Latest one month sales total (dollars)

Age - Median age of customer base (years)

HS - Percentage of customer base with a high school diploma

College - Percentage of customer base with a college diploma

Growth - Annual population growth rate of customer base over the past 10 years.

Income - Median family income of customer base (dollars)

a. Construct a scatter plot, using sales as the dependent variable and median family income as the independent variable. Discuss the scatter plot.

b. Assuming a linear relationship, use the least-squares method to compute the regression coefficients b0 and b1.

c. Interpret the meaning of the Y-intercept, b0, and the slope, b1, in this problem.

d. Compute the coefficient of determination r2, and interpret its meaning.

e. Construct a 95% confidence interval estimate of the population slope and interpret its meaning.

Sales - Latest one month sales total (dollars)

Age - Median age of customer base (years)

HS - Percentage of customer base with a high school diploma

College - Percentage of customer base with a college diploma

Growth - Annual population growth rate of customer base over the past 10 years.

Income - Median family income of customer base (dollars)

a. Construct a scatter plot, using sales as the dependent variable and median family income as the independent variable. Discuss the scatter plot.

b. Assuming a linear relationship, use the least-squares method to compute the regression coefficients b0 and b1.

c. Interpret the meaning of the Y-intercept, b0, and the slope, b1, in this problem.

d. Compute the coefficient of determination r2, and interpret its meaning.

e. Construct a 95% confidence interval estimate of the population slope and interpret its meaning.

**View Solution:**## Answer to relevant Questions

a. You are the manager of a fast food restaurant. You want to determine whether the population means waiting time to place an order has changed in the past month from its previous population mean value of 4.5 minutes. From ...To answer this question, use the Data Analysis Toolpack in Excel and select “t-Test: Two-Sample Assuming Equal Variances” from the list of available tools. Explain your answer (how did you decide if men spend more) and ...Rudy Sandberg wants to invest in four-year bonds that are currently priced at $879.35. These bonds have a coupon rate of 6.01 percent and pay semiannual coupons.The current market yield on this bond is.Western Pipeline, Inc., has been very successful in the last five years. Its $1,000 par value convertible bonds have a conversion ratio of 28. The bonds have a quoted interest rate of 5 percent a year. The firm’s common ...After completing its capital spending for the year, Carlson Manufacturing has $1,000 extra cash. Carlson's managers must choose between investing the cash in Treasury bonds that yield 8 percent or paying the cash out to ...Post your question