Goods Project Word Document

Goods Project Word Document - Bryan Redd Data Set 0F8...

Info iconThis preview shows pages 1–4. Sign up to view the full content.

View Full Document Right Arrow Icon
Bryan Redd Data Set 0F8 Demand Forecast and Regression Analysis of Scooters sold by Scooters Sportsworld
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Section A The purpose of this project is to forecast the number of scooters that will be sold in February 2009 by Scooters Sportsworld. This report is being prepared for Mr. Jose Hernandez, who is an inventory manager for Scooters Sportsworld. I am being asked to prepare a multiple regression report that will help Jose effectively forecast how many scooters to order for the month of February. It is my job to determine the significance of the variables in question. Table 1: Variable Names and Definitions Name Variable Description (all are monthly values) Sales Number of scooters sold TV Television advertising expenses ($1,000s) Newspaper Newspaper advertising expenses ($1,000s) Gas Average price of gasoline futures markets ($ per gallon) Associates Average number of sales associates during operating hours Bonus Average value of bonus bucks ($ per scooter sold) List Average list price of scooters sold ($) Promo 1 for month with a sales promotion; 0 if no sales promotion
Background image of page 2
Section B 1. Outlier Assessment In order to detect outliers you must look at the descriptive statistics of the quantitative independent variables. All of the independent variables in the data set are being assessed for outliers except the variable promo, because it is a qualitative instead of quantitative variable. The only variable that contains potential outliers is average value of bonus. The potential outliers occur in November 2007, December 2007, and May 2008 when the average value of bonus bucks per scooter was equal to 3,045 dollars per scooter. Table 2: Excel Descriptive Statistics Output
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 4
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 08/08/2011 for the course WCOB 2023 taught by Professor Billthompson during the Spring '07 term at Arkansas.

Page1 / 10

Goods Project Word Document - Bryan Redd Data Set 0F8...

This preview shows document pages 1 - 4. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online