Calculate a regression forecast for month

Assignment Help Financial Accounting
Reference no: EM131790400

Regression Forecast. Using the data in the table for questions #7 calculate the four items below. You may do this on your calculator or in Excel, however, please be sure to indicate the primary formula that you would use for each calculation. If you make your calculations in Excel be sure to export your work into Word before submitting your work to your mentor.

a. What is the slope? The slope is

b. What is the intercept?

c. Write the regression equation.

d. Calculate a regression forecast for month 25.

Table. Actual Sales Data
Time Period Actual Sales ($000)
1 445
2 478
3 525
4 660
5 570
6 600
7 632
8 648
9 690
10 725
11 750
12 722

Reference no: EM131790400

Questions Cloud

Prepare the planning and flexible budgets and show a report : Prepare the planning and flexible budgets and show a report showing the company's activity variances for October
Explain the conventional accounting concept : Explain the conventional accounting concept of depreciation accounting. What depreciation methods might be used for the computer system
Prepare segmented income statements for system a : Prepare segmented income statements for System A and the headsets assuming that System B is dropped. Should B be dropped?
How many units of the good are imported or exported : Suppose the world price is P = 6. Add this to your drawing and determine how many units of the good are imported or exported by the country.
Calculate a regression forecast for month : If you make your calculations in Excel be sure to export your work into Word before submitting your work to your mentor
Prepare income tax expense section of the income statement : Prepare the income tax expense section of the income statement for 2010, beginning with "Income before income taxes
Which would be the largest and which would be the smallest : Find the area to the right of the given z-score in a standard Normal distribution. In this question, round your answers to the nearest 0.000.
Calculate the break-even in both dollars and units : Calculate the break-even in both dollars and units for 2015. Calculate the margin of safety in both units and sales dollars.
Prepare a schedule computing the equity income : Miller's policy is to pay a $1 per share cash dividend every April 1. Prepare a schedule computing the equity income to be recognized by Gibson during 2007

Reviews

Write a Review

Financial Accounting Questions & Answers

  Financial statement analysis and preparation

Financial Statement Analysis and Preparation

  Shareholder of a company

Describe the ways that a person can become a shareholder of a company. Why Wal-Mart would split its stock?

  Financial and accounting principles

An understanding of financial and accounting principles can be a valuable tool for managers. While not all managers will find themselves calculating financial ratios or preparing annual financial data.

  Prepare a statement of cash flow using the direct method

Prepare a Statement of Cash Flow using the Direct Method and Prepare the Operations section of the Statement of Cash Flow using the Indirect Method.

  Financial accounting assignment

This assignment has one case study and two question apart from case study. Questions related to document Liquidation question and Company financial statements question - Torquay Limited

  Prepare general journal entries for goela

Prepare general journal entries for Goela Ltd

  Principles of financial accounting

Prepare the journal entry to record the acquisition of the assets.

  Prepare general journal entries to record the transactions

Prepare general journal entries to record the transactions, assuming use of the periodic inventory system

  Global reporting initiative

Compare the view espoused by the economist Milton Friedman about the social responsibilities of business with the views express by Stigler.

  Explain the iasb conceptual frameworks

Explain the IASB Conceptual Framework's perspective of users and their decisions.

  Determine the company''s financial statements

T he focus of the report is to determine the extent to which you are comfortable relying on the financial statements as presented by management .

  Computation of free cash flow

Computation of Free Cash Flow

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!

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