Regression mastery problem - session 5 a senior financial

Reference no: EM13483755 , Length: 15

Regression Mastery Problem - Session 5 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): 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 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: EM13483755

Questions Cloud

The companys board of directors has declared a dividend of : determining the amount of a dividend - cole company has 288000 shares of common stock authorized 260000 shares issued

Foulds company makes 13000 units per year of a part it uses : foulds company makes 13000 units per year of a part it uses in the products it manufactures. the unit product cost of

The balance sheet for ronlad corporation reported 168000 : computing the number of unissued shares - the balance sheet for ronlad corporation reported 168000 shares outstanding

Velazques jeep tours operates jeep tours in the heart of : velazques jeep tours operates jeep tours in the heart of the colorado rockies. the company bases its budgets on two

Regression mastery problem - session 5 a senior financial : regression mastery problem - session 5 a senior financial analyst with ace gadgets ag is attempting to get a better

Does a stock dividend increase an investors personal wealth : does a stock dividend increase an investors personal wealth immediately?a. no because the stock price falls when a

File the james income tax return form 1040 schedules a d : lyle and kaye james are married have two minor children jessica age 8 and jerron age 4 and are filing a joint tax

When treasury stock is purchased with cash what is the : when treasury stock is purchased with cash what is the impact on the balance sheet equation?a. no change the reduction

As part of the initial investment a partner contributes : 1.on may 1 20xx a firm purchased a 1 year insurance policy for 1800 and paid the full premium in advance. the insurance

User Account

All Pages