User Account

All Pages

Correlation between the above variables and sales

Assignment Help Corporate Finance
Reference no: EM13211493

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

Questions Cloud

Compute the molar mass that would be obtained : Calculate the molar mass that would be obtained from the actual experimental data under the following conditions. The unknown is methyl propyl ether (CH3OC3H7)
Prepare a trend analysis of operating ratios : Prepare a trend analysis of operating ratios for at least 3 years' worth of financial data and perform a business analysis (both external and internal) for your company using the most recent information fromvarious sources.
Compute the molar mass that would be obtained : Calculate the molar mass that would be obtained from the actual experimental data under the following conditions. The unknown is methyl propyl ether (CH3OC3H7)
Explain the half-reactions and the respective standard : Based on the half-reactions and their respective standard reduction potentials below, which addition to an aqueous solution containing Fe(NO3)2 will result in a reaction under standard-state conditions?
Correlation between the above variables and sales : Create a scatterplot between the variable that you selected in requirement 2 and sales. Properly label your chart - Regression Mastery Problem
Explain shorthand notation for the galvanic cell reaction : The shorthand notation for the galvanic cell reaction Fe3+(aq) + 2 I-(aq) ? Fe2+(aq) + I2(s) requires an inert electrode on A) only on the right side of the salt bridge
Compute the standard potential of cell : the electrode half-reactions and calculate the standard potential of the following cell: Cu / Cu2+(aq) // Mn2+(aq),H+(aq) / MnO2(s) / Pt
Midlands acquisition of shipley wireless identify : What special asset does Midland's acquisition of Shipley Wireless identify? How should Midland Telecom account for this asset after acquiring Shipley Wireless? Explain in detail.
How to carried out a radical chlorination reaction : Assume that you have carried out a radical chlorination reaction on (R)-2- chloropentane and have isolated (in low yield) 2,4-dichloropentane.

Reviews

Write a Review

Corporate Finance Questions & Answers

  How much additional spendable income will each investor have

How much additional spendable income will each investor have if the business is organized as a partnership rather than as a corporation?

  How much would you pay for the stock

Evaluate how much do you need to save from year 30 to 50 to accumulate enough for your retirement fund, if the ROR is 10%

  Prepare companys consolidated balance sheet

Evaluate the three largest assets. Be sure to look at all the assets, not just the current assets and describe whether you believe the company has invested in the appropriate types of assets for this company.

  Cost of capital assignment

AMETEK, Inc. (AME) manufactures and sells electronic instruments and electromechanical devices in North America, Europe, Asia, and South America. The company operates in two segments, Electronic Instruments Group and Electromechanical Group. The divi..

  Find the real gdp percent

Assume nominal GDP in 1999 was 100 billion dollar & in 2001 it was 270 billion dollar. The general price index in 1999 was 100 & in 2001, it was 150.

  Energy risk hedging using swaps

We focused on the futures markets and how simple hedges can be accomplished using exchange-traded contracts. Energy Risk Hedging Using Swaps, Spreads and Options

  Explain what is aq&qs indifference level of ebit

Explain what is AQ&Q's indifference level of EBIT and provide its current situation, might it benefit from increasing or decreasing its use of debt? Explain.

  What possible danger exists for the class b shareholders

What percent of the votes do the Class B shares hold and what type of share is the Class A

  Valuation of stock using capm

Valuation of stock using CAPM - Estimate the value of Cargo Point, Inc. stock.

  Compute current and quick ratios for companies

Compute the items for Lone Pine Company for 20X2, rounding all calculations to two decimal places when necessary- Quick ratio

  Financial intermediaries

Financial institutions are subject to regulations to ensure that they do not take many risk & can safely facilitate the flow of funds through financial markets.

  Correlation between the variables and sales

What is the correlation between the variables and sales and which variable appears to have the strongest relationship with sales? Why do you suggest this variable?

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