User Account

All Pages

Which variables in the current regression model

Assignment Help Financial Management
Reference no: EM13978458

Consider the following time series data representing quarterly sales of dishwashers at Big Boys Appliances over the past two years: 

1140_68-B-F-F-M (167).png

The scatter plot of the data above shows seasonality with trend. Hence, a multiple regression model is run to forecast the demand. We denote sales (Y) as the depend variable, and denote time (t, with t = 1 represent the first quarter of 2010) and dummy variables (S2, S3, and S4) as independent variables. Here, we choose quarter 1 as the baseline and adopt three seasonality dummy variables, such that S2 = 1 represents quarter 2, S3 = 1 represents quarter 3, and S4 = 1 represents quarter 4. Answer the following questions. Use α = 0.05. 

a. Use the above variable definition to code the data above.

b. Copy the data into Excel and run the corresponding multiple regression. Write the estimated multiple regression equation use the variables defined above. 

c. Which variables in the current regression model are significant? And which are not significant? Justify your answer with p-values. 

Reference no: EM13978458

Questions Cloud

Find the magnitude of the magnetic force exerted : Consider a current loop immersed in a magnetic field, as in Figure 22-34(a). It is given that B = 0.27 T and I = 9.5 A. In addition, the loop is a square 0.51 m on a side. Find the magnitude of the magnetic force exerted on each side of the loop.
The point of view of an educator : Jen Holladay discussed in her TED talk what she believes multiculturalism should look like in our modern world. What parts of her vision do you agree/disagree with and why? Do you think that the perspective changes depending on whether you look at th..
Which of the following was the first system of writing : The ideology that best explains Hammurabi's position with respect to commercial transactions was
Alcohol consumption alters : The premise of her question is that alcohol consumption alters our perception of attractiveness. Imagine that an experimenter wanted to determine if this change in our perception of attractiveness was related to our experience with alcohol
Which variables in the current regression model : Which variables in the current regression model are significant? And which are not significant? Justify your answer with p-values.
Find the net energy transferred to the system by heat : If Q is negative for the process BC and ?Eint is negative for the process CA, what are the signs of heat(Q), work(W) and change in the internal energy(?Eint) that are associated with each of the three processes?
Find the simple linear regression model : Find the simple linear regression model, and interpret the meaning of the slope in the setting of this problem.Complete the ANOVA Table
What is the final speed of each cart : Two carts collide in a perfectly elastic collision. What is the final speed of each cart? If they make a completely inelastic collision, what would their final speed be?
Describe the content of a traditional expatriate package : Describe the content of a 'traditional' expatriate package, and the reasons of the company to provide such benefits! What limitations do you see in this contract when it comes to handling the company's emerging needs

Reviews

Write a Review

Financial Management Questions & Answers

  Bonds make semiannual payments and have par value

Sqeekers Co. issued 15-year bonds a year ago at a coupon rate of 8.1 percent. The bonds make semiannual payments and have a par value of $1,000. If the YTM on these bonds is 6.4 percent, what is the current bond price?

  Incremental interest cost of borrowing the extra money

A borrower is purchasing a property for $300,000 and can choose between two possible loan alternatives. The first is a 90% loan for 20 years at 6.0% interest and the second is an 80% loan for 20 years at 5.0% interest. Assume the loan will be held to..

  What is the present value of a growing perpetuity

What is the present value of a growing perpetuity that makes a payment of $100 in the first year, which thereafter grows at 3% per year? Apply a discount rate of 7%.

  Explain the role of government in international trade the

explain the role of government in international trade the various levels of economic integration and the impact on

  Convert the standard return into a log return

Suppose that, over a 125 day period, Mike Inc.'s stock price experienced (positive) Standard Returns of 12%. Convert the Standard Return into a Log Return. What would the annualized Standard Return be?

  What is present value of acquired tax loss carry forwards

In Sept. 2008, the IRS changed tax laws to allow banks to utilize the tax loss carry forwards of banks they acquire to shield their future income from taxes (prior law restricted the ability of acquirers to use these credits). what is the present val..

  Pension funds pay lifetime annuities to recipients

Pension funds pay lifetime annuities to recipients. If a firm will remain in business indefinitely, the pension obligation will resemble perpetuity. Suppose, therefore, that you are managing a pension fund with obligations to make perpetual payments ..

  What is the net present value of acquiring

ABC and XYZ are all-equity firms. ABC has 1,750 shares outstanding at a market price of $20 a share. XYZ has 2,500 shares outstanding at a price of $28 a share. XYZ is acquiring ABC for $36,000 in cash. The incremental value of the acquisition is $3,..

  Pension funds and financial planning

1. What role do you think insurance companies play when it comes to pension funds and financial planning?

  How much cash does the company have

Saunders Corp. has a book net worth of $13,430. Long-term debt is $8,650. Net working capital, other than cash, is $3,305. Fixed assets are $17,830 and current liabilities are $1,810. How much cash does the company have? What is the value of the curr..

  Unsure about the assumptions of a growth rate

The Yurdone Corporation wants to set up a private cemetry business. According to the CFO, Barry M. Deep, business is "looking up". The company is somewhat unsure about the assumptions of a growth rate of 5.7 percent its cash flows. At what constant g..

  Firm is owed an account receivable-money market hedge

Suppose your firm is owed an account receivable of C$1,000,000 due on Dec. 23, 2015. Treat this as a one-month hedge. Show how you would hedge this debt with: a money market hedge (use appropriate borrowing and lending rates),

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