A senior financial analyst with ace gadgets ag is

Reference no: EM13381794

A senior financial analyst with Ace Gadgets (AG) is attempting to get a better grasp on sales forecasting for AG's new franchises. She has obtained various details for 27 existing franchises including

Sales (Annual)
Square feet of the store
Inventory
Advertising $ (annual)
Number of competing stores in the district

From her recollection of her undergraduate course in statistics, she thought of regression analysis as a possibility in modeling new franchise sales. She has enlisted your help in this modeling task and has provided you with this list of questions.

1. What is the correlation between the above variables and sales?

2. Which variable appears to have the strongest relationship with sales? Why do you suggest this variable?

3. Create a scatterplot between the variable that you selected in requirement 2 and sales. Properly label your chart.

4. Add a trend line to the requirement 3 chart along with the regression equation and R2.

5. Interpret (in layman's language) what the equation means and what the R2means. Remember that the senior analyst (senior ≈ old) hasn't had a course in statistics in several years and needs an interpretation that is understandable. Be sure to include all elements of the equation.

6. Using the analysis toolpak add-in, run regression analysis using the variable that you selected in requirement 2.

7. Using the output from requirement 6, is this variable statistically significant in predicting sales? What specifically on the output allows you to reach this conclusion1?

8. Which variables from the above list are useful in predicting sales? Why?

9. Using an appropriate Excel function, if a new franchise decided to carry $300,000 in inventory, what can be the expected annual sales for this franchise? Are you 100% confident in your answer? Why or why not?

Reference no: EM13381794

Questions Cloud

Chips home brew whiskey management forecasts that if the : chips home brew whiskey management forecasts that if the firm sells each bottle of snake-bite for 20 then the demand

Your organization is a manufacturing company with employees : your organization is a manufacturing company with employees in the following provincesnewfoundland and labradornova

Research and analyze the global equity and bond markets to : research and analyze the global equity and bond markets to create an faq sheet that could be given to prospective

Your grandparents have been left a substantial amount of : your grandparents have been left a substantial amount of money and want to invest in a company. your grandfather trusts

A senior financial analyst with ace gadgets ag is : a senior financial analyst with ace gadgets ag is attempting to get a better grasp on sales forecasting for ags new

Midland telecom provides communication services in iowa : midland telecom provides communication services in iowa nebraska the dakotas and montana. midland purchased goodwill as

Part a part a of this assignment requires an analysis of : part a part a of this assignment requires an analysis of certain aspects of brown ltdafter studying brown ltd answer

Given the us global financial crisis of 2007-2009 do you : given the u.s. global financial crisis of 2007-2009 do you anticipate any changes to the systems of fixed exchange

The cost of capital for goff computer inc you have recently : the cost of capital for goff computer inc. you have recently been hired by goff computer inc. gci in the finance area.

User Account

All Pages