Regression Analysis

Good Essays
Assignment # 1

Forecasting (Total marks: 100)

Following 10 Problems are for submission

Problem 1: [12]

Registration numbers for an accounting seminar over the past 10 weeks are shown below:

|Week 1 2 3 4 5 6 7 8 9 10 |
|Registrations 24 23 28 30 38 32 36 40 44 40 |

a) Starting with week 2 and ending with week 11, forecast registrations using the naive forecasting method. [2] b) Starting with week 3 and ending with week 11, forecast registration using a two-week moving average. [3] c) Starting with week 5 and ending with week 11, forecast registrations using a four-week moving average. [3] d) Plot the original data and the three forecasts on the same graph. Which forecast smoothes the data the most? Which forecast responds to change the best? [4]

Problem 2 [4] Given the following data, use exponential smoothing (( = 0.3) to develop a demand forecast. Assume the forecast for the initial period is 5.

|Period 1 2 3 4 5 6 |
|Demand 7 9 5 9 13 8 |

Problem 3 [6] Calculate (a) MAD and (b) MSE for the following forecast versus actual sales figures:

|Forecast |104 |112 |125 |132 |
|Actual | 95 |108 |128 |136 |

Problem 4 [16] Sales of industrial vacuum cleaners at Larry Armstrong Supply Co. over the past 13 months are shown below:

|Month |Jan. |Feb. |March |April |May |June |July |
|Sales (in thousands) |11 |14 |16 |10 |15 |17 |11 |
|Month

You May Also Find These Documents Helpful

  • Powerful Essays

    Regression Analysis

    • 2062 Words
    • 9 Pages

    REGRESSION ANALYSIS (SIMPLE LINEAR REGRESSION) Submitted By Maqsood Khan MS - MANAGEMENT SCIENCES, 2nd SEMESTER Submitted TO GOHAR REHMAN ASSISTANT: PROFESSOR, SUIT Sarhad University Of Science And Information Technology Peshawar SESSION: 2012-13 TABLE OF CONTENTS |S. No. |Subjects |Page No. | |1 | |Introduction…

    • 2062 Words
    • 9 Pages
    Powerful Essays
  • Good Essays

    Regression Analysis

    • 705 Words
    • 3 Pages

    Regression Analysis Abstract Quantile regression. The Journal of Economic Perspectives This paper is formulated towards that of regression analysis use in the business world. The article used for this paper was written in order to understand the meaning of regression as a measurement tool and how the tool uses past business data for the purpose of future business economics. The research mentioned in this article pertained to quantile regression, or how percentiles of specific data are used in…

    • 705 Words
    • 3 Pages
    Good Essays
  • Good Essays

    Regression Analysis

    • 1438 Words
    • 6 Pages

    REGRESSION ANALYSIS Correlation only indicates the degree and direction of relationship between two variables. It does not, necessarily connote a cause-effect relationship. Even when there are grounds to believe the causal relationship exits, correlation does not tell us which variable is the cause and which, the effect. For example, the demand for a commodity and its price will generally be found to be correlated, but the question whether demand depends on price or vice-versa; will not be answered…

    • 1438 Words
    • 6 Pages
    Good Essays
  • Good Essays

    Regression Analysis

    • 1480 Words
    • 6 Pages

    Quantitative Methods Project Regression Analysis for the pricing of players in the Indian Premier League Executive Summary The selling price of players at IPL auction is affected by more than one factor. Most of these factors affect each other and still others impact the selling price only indirectly. The challenge of performing a multiple regression analysis on more than 25 independent variables…

    • 1480 Words
    • 6 Pages
    Good Essays
  • Satisfactory Essays

    Regression Analysis

    • 4013 Words
    • 17 Pages

    1. Chi-square Goodness-of-fit Tests Jake is trying to invest his money in stock market, is not sure that he could earn a profit or lose his money when he invests to an AT&T company’s stock or a stock market index, Dow Jones Industry Average. So he called his friend who works at financial consulting company and heard that the monthly positive and negative investment returns on AT&T and Dow Jones Industry Average were historically almost the same. However the economic situation recently has been getting…

    • 4013 Words
    • 17 Pages
    Satisfactory Essays
  • Better Essays

    Regression Analysis

    • 1285 Words
    • 6 Pages

    Introduction This presentation on Regression Analysis will relate to a simple regression model. Initially, the regression model and the regression equation will be explored. As well, there will be a brief look into estimated regression equation. This case study that will be used involves a large Chinese Food restaurant chain. Business Case In this instance, the restaurant chain 's management wants to determine the best locations in which to expand their restaurant business. So far the most…

    • 1285 Words
    • 6 Pages
    Better Essays
  • Satisfactory Essays

    Regression Analysis

    • 1048 Words
    • 6 Pages

    Mortality Rates Regression Analysis of Multiple Variables Neil Bhatt 993569302 Sta 108 P. Burman 11 total pages The question being posed in this experiment is to understand whether or not pollution has an impact on the mortality rate. Taking data from 60 cities (n=60) where the responsive variable Y = mortality rate per population of 100,000, whose variables include Education, Percent of the population that is nonwhite, percent of population that is deemed poor, the precipitation…

    • 1048 Words
    • 6 Pages
    Satisfactory Essays
  • Powerful Essays

    Regression Analysis

    • 5540 Words
    • 23 Pages

    l Regression Analysis Basic Concepts & Methodology 1. Introduction Regression analysis is by far the most popular technique in business and economics for seeking to explain variations in some quantity in terms of variations in other quantities, or to develop forecasts of the future based on data from the past. For example, suppose we are interested in the monthly sales of retail outlets across the UK. An initial data analysis would summarise the variability in terms of a mean and standard…

    • 5540 Words
    • 23 Pages
    Powerful Essays
  • Satisfactory Essays

    Regression Analysis

    • 434 Words
    • 2 Pages

    Regression Analysis Exercises 1- A farmer wanted to find the relationship between the amount of fertilizer used and the yield of corn. He selected seven acres of his land on which he used different amounts of fertilizer to grow corn. The following table gives the amount (in pounds) of fertilizer used and the yield (in bushels) of corn for each of the seven acres. |Fertilizer Used |Yield of Corn | |120…

    • 434 Words
    • 2 Pages
    Satisfactory Essays
  • Good Essays

    Regression Analysis

    • 619 Words
    • 3 Pages

    I met with Talon Peterson and administered 2 different reading test/tasks. First he completed a post test of the Renaissance Star test. This test is vocabulary and comprehension so the results are a fairly good indicator of overall reading ability. What Star won't measure is fluency which is a major factor in determining a student's ability to keep pace with their peers on reading and writing tasks. Results are reported in grade year and month. His scores were as follows: Baseline Testing:…

    • 619 Words
    • 3 Pages
    Good Essays