Question

Use regression analysis to examine the variation in a dependent variable. Use 0.05 level of significance unless other stated.

- When doing various tests (fit, significance) report the relevant values of the parameters (test stats, R square)
- Make sure to write out your hypotheses and rejection rules for significance tests. If p-values are greater than 0 report the level at which your test is significant.
- Conclusions are to be in terms of the problems; pretend the reader has no idea about you were asked to do.
**Do not include**the confidence interval data in your report (will fit the page better)

Sunflower Clothing Chain

3. Sales for Sunflowers, a clothing chain, have increased during the past 12 years as the chain expanded the number of stores open. Until now, Sunflowers’ senior managers selected sites based on subjective factors. As the new director of planning, you will need to develop a systematic approach to selecting new sites. This plan must be able to forecast annual sales for all potential stores under consideration. You believe that the size of the store significantly contributes to the success of a store and want to use this relationship in the decision-making process.

Examine the relationship between the store size (thousands of square feet) and its annual sales (in million dollars) for Sunflowers women's clothing chain.

- Identify the regression equation.
- Interpret slope coefficient and test its significance.
- How well does the equation fit the data?
- Does the equation significantly explain the relationship between Sunflower's annual sales and the size of its stores?

SUMMARY OUTPUT | |||||

Regression Statistics | |||||

Multiple R | 0.85 | ||||

R Square | 0.73 | ||||

Adjusted R Square | 0.71 | ||||

Standard Error | 1.69 | ||||

Observations | 14.00 | ||||

ANOVA | |||||

df | SS | MS | F | Significance F | |

Regression | 1 | 92.34 | 92.34 | 32.26 | 0.00 |

Residual | 12 | 34.34 | 2.86 | ||

Total | 13 | 126.68 | |||

Coefficients | Standard Error | t Stat | P-value | ||

Intercept | 1.02 | 0.92 | 1.11 | 0.29 | |

Square Feet (000) | 1.56 | 0.27 | 5.68 | 0.00 |

Answer #1

- Identify the regression equation.

y = 1.02 + 1.56*x

- Interpret slope coefficient and test its significance.

For every square foot, sales will increase by 1.56.

The hypothesis being tested is:

H0: β1 = 0

H1: β1 ≠ 0

The p-value is 0.00.

Since the p-value (0.00) is less than the significance level (0.05), we can reject the null hypothesis.

Therefore, we can conclude that the slope is significant.

- How well does the equation fit the data?

0.73 = 73% of the variation in the model is explained. This is a good fit.

- Does the equation significantly explain the relationship between Sunflower's annual sales and the size of its stores?

Yes

Please give me a thumbs-up if this helps you out. Thank you!

The general manager of
a chain of pharmaceutical stores reported the results of a
regression analysis, designed to predict the annual sales for all
the stores in the chain (Y) – measured in millions of dollars. One
independent variable used to predict annual sales of stores is the
size of the store (X) – measured in thousands of square feet. Data
for 14 pharmaceutical stores were used to fit a linear model. The
results of the simple linear regression are...

The general manager of a chain of pharmaceutical stores reported
the results of a regression analysis, designed to predict the
annual sales for all the stores in the chain (Y) – measured in
millions of dollars. One independent variable used to predict
annual sales of stores is the size of the store (X) – measured in
thousands of square feet. Data for 14 pharmaceutical stores were
used to fit a linear model. The results of the simple linear
regression are...

Use Data Analysis in Excel to conduct the Regression Analysis to
reproduce the excel out put below (Note: First enter the data in
the next page in an Excel spreadsheet)
Home Sale Price: The table below provides the Excel output of a
regression analysis of the relationship between Home sale price(Y)
measured in thousand dollars and Square feet area
(x):
SUMMARY OUTPUT
Dependent:
Home Price
($1000)
SUMMARY OUTPUT
Dependent:
Home Price
($1000)
Regression Statistics
Multiple R
0.691
R Square
0.478...

We give JMP output of regression analysis. Above output we give
the regression model and the number of observations, n,
used to perform the regression analysis under consideration. Using
the model, sample size n, and output:
Model: y = β0 +
β1x1 +
β2x2 +
β3x3 +
ε Sample size:
n = 30
Summary of Fit
RSquare
0.956255
RSquare Adj
0.951207
Root Mean Square Error
0.240340
Mean of Response
8.382667
Observations (or Sum Wgts)
30
Analysis of Variance
Source
df
Sum...

1. Jensen Tire & Auto is in the process of deciding whether
to purchase a maintenance contract for its new computer wheel
alignment and balancing machine. Managers feel that maintenance
expense should be related to usage, and they collected the
information on weekly usage (hours) and annual maintenance expense
(in thousands of dollars).
SUMMARY OUTPUT
Regression Statistics
Multiple R
0.9272
R Square
0.8597
Adjusted R Square
0.8422
Standard Error
4.1466
Observations
10
ANOVA
df
SS
MS
F
Significance F
Regression...

Part C: Regression and Correlation Analysis
Use the dependent variable (labeled Y) and the independent
variables (labeled X1, X2, and X3) in the data file. Use Excel to
perform the regression and correlation analysis to answer the
following.
Generate a scatterplot for the specified dependent variable (Y)
and the X1 independent variable, including the graph of the "best
fit" line. Interpret.
Determine the equation of the "best fit" line, which describes
the relationship between the dependent variable and the selected...

Regression Analysis with a Minitab output
Assume that your company owns multiple retail outlets in cities
across the United States. You conduct a study to determine if daily
sales levels (in hundreds of dollars) can be predicted by the
number of competitors that are located within a one-mile radius of
each location and city population (in thousands of people).
Therefore, the dependent variable is SALES and the two independent
variables are NUMBER OF COMPETITORS and CITY POPULATION. Your
research team...

Please answer the following Case
analysis questions
1-How is New Balance performing compared to its primary rivals?
How will the acquisition of Reebok by Adidas impact the structure
of the athletic shoe industry? Is this likely to be favorable or
unfavorable for New Balance?
2- What issues does New Balance management need to address?
3-What recommendations would you make to New Balance Management?
What does New Balance need to do to continue to be successful?
Should management continue to invest...

Please read the article and answear about
questions.
Determining the Value of the Business
After you have completed a thorough and exacting investigation,
you need to analyze all the infor- mation you have gathered. This
is the time to consult with your business, financial, and legal
advis- ers to arrive at an estimate of the value of the business.
Outside advisers are impartial and are more likely to see the bad
things about the business than are you. You should...

ADVERTISEMENT

Get Answers For Free

Most questions answered within 1 hours.

ADVERTISEMENT

asked 54 minutes ago

asked 55 minutes ago

asked 1 hour ago

asked 1 hour ago

asked 1 hour ago

asked 1 hour ago

asked 1 hour ago

asked 2 hours ago

asked 2 hours ago

asked 2 hours ago

asked 2 hours ago

asked 2 hours ago