A senior financial analyst with ace gadgets ag is

Reference no: EM13389358

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 (see associated spreadsheet):

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 R2 means. 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: EM13389358

Questions Cloud

The following accounts increased during 2014 accounts : bloom corporation had the following 2014 income statementsales

State what a value chain dispersal and integration strategy : research a top multinational company in the world including its international strategy over the last 10 years. using

Determine optimal output and price and its profit because : a small tractor producing firms total cost and demand equations are as followsc 37500000 5000q 1.5q2p 30000 - qa.

Please select 4 companies and summarize similarities and : please select 4 companies and summarize the similarities and differences in reporting the financial performance and the

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 agrsquos

Choose a business forecasting method qualitative or : describe how lean production principles may be used to maximize the efficiency and effectiveness of the electric fan

Deduce the firms short-run supply equation find out the : in a competitive industry the short-run average variable cost avc of a firm isavc 600 - 20q - 0.5q2a. derive the firms

Describe the lower of cost or market method of evaluating : explain the lower of cost or market method of evaluating inventory. give an example of when lcm would be used. what is

Potential advantages and challenges related with : write a 1400- to 1750-word paper on essential communication in a community crisis situation described in the

User Account

All Pages