User Account

All Pages

A senior financial analyst with ace gadgets ag is

Assignment Help Finance Basics
Reference no: EM13480186

Regression Mastery Problem

A senior financial analyst with Ace Gadgets (AG) is attempting to get a better grasp on sales forecasting for AG'snew 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 conclusion 1?

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: EM13480186

Questions Cloud

Frontier sports sells hunting and fishing equipment and : frontier sports sells hunting and fishing equipment and provides guided hunting and fishing trips. frontier sports is
How do people use language to style themselves - to take on : how do people use language to style themselves - to take on a particular persona or juggle between personae in
Your grandparents have been left a substantial amount of : financial statement analysisyour grandparents have been left a substantial amount of money and want to invest in a
If the sales price of the used machine was 1200 the : 1 which of the following is not capitalized when a piece of production equipment is acquired for a factory?sales
A senior financial analyst with ace gadgets ag is : regression mastery problema senior financial analyst with ace gadgets ag is attempting to get a better grasp on sales
Determine the minimum floor price that shorewood shoes : special order pricing - shorewood shoes company makes and sells a variety of leather shoes for children.nbspnbspfor its
Topper corporation has 60000 shares of 1 par value common : topper corporation has 60000 shares of 1 par value common stock and 16000 shares of cumulative 7 100 par preferred
What other considerations will george want to consider : dropping a segment - georges grill analyzes profitability of three operating units restaurant bar and billiards
Varilux manufactures a single product and sells it for 10 : varilux manufactures a single product and sells it for 10 per unit. at the beginning of the year there were 1000 units

Reviews

Write a Review

Finance Basics Questions & Answers

  Computation of number of units to be sold to cover target

Computation of number of units to be sold to cover target dollar amount and How many tickets the Mavericks have to sell to pay for the entire Mavericks team

  Considering genesisrsquos aggressive growth plan sensible

considering genesisrsquos aggressive growth plan sensible essentials suggested that its client should broaden the scope

  Computation of return of a given portfolio

Computation of return of a given portfolio of amount invested and this year nothing has changed except for the fact that the market risk premium has increased by 2 percent

  Which of the following statements is most incorrect

A 10-year corporate bond has an annual coupon rate of 9%. The bond is currently selling at premium. Which of the following statements is most incorrect?

  What is the accurate real rate of return on these securities

If inflation is anticipated to be 10 percent during the next year while a nominal rate of 20 percent will be earned on U.S. Treasury bills, then what is the accurate real rate of return on these securities?

  Calculate cash flow for the year

Cash Flows: A new project will generate sales of $74 million, costs of $42 million, and depreciation expense of $10 million in the coming year. The firm's tax rate is 35%. Calculate cash flow for the year by using all three methods listed below, a..

  Suppose you just inherited an oil well this oil well is

suppose your bank account will be worth 4200.00 in one year. the interest rate discount rate that the bank pays is 5.

  What is the sustainable rate of growth

The Green Giant has a 6 percent profit margin and a 60 percent dividend payout ratio. The total asset turnover is 1.3 and the equity multiplier is 1.6. What is the sustainable rate of growth?

  Objective question based on finance

Tangshan Mining has common stock at par of $200,000, paid in capital in excess of par of $400,000, and retained earnings of $280,000.

  What required return must investors be demanding on ontario

Ontario Wine just paid a dividend of $1.50 on its stock, which currently sells for $50 per share. What required return must investors be demanding on Ontario Wine stock?

  Find the amount of the final sinking fund deposit

The total annual payments will be level at $3,300 until a final smaller annual payment suffices to pay off the loan. Find the amount of the final sinking fund deposit.

  What is the portfolio beta

You own a portfolio invested 25.49% in Stock A, 14.87% in Stock B, 23.07% in Stock C, and the remainder in Stock D. The beta of these four stocks are 1.23, 1.2, 0.36, and 1.07. What is the portfolio beta?

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd