Statistics Homework Solutions
Problem
#5269

Problem with statistics

I am having problems calculating this trend. Please help I came up with these numbers and I know it is wrong.
X totals 10, y totals 472000, xy totals 1205000, x2 totals 30
X=10/3=3.33   Y-472000/3=157333.33
B.)120500-(10)(3.33)(157333.333)/30-(10)(3.33)(3.33)
=50427.49
A.) 157333.33-(50427.49)(3.33)=10590.21
^
Y +10590.21+50427.49X
10590.21+50427.49(4)=212300.17

Attached file(s):
Attachments
table 5.doc  View File

Attachment Content Summary (Note: view attachment at the above link before purchasing. Actual attachment content may vary slightly from that shown below.)

table 5.doc
The table below presents 4 years of quarterly sales for Mary’s
Mongoose Menagerie. Marty wants to know what quarterly sales will be in
2002. Project quarterly sales for 2002 using trend analysis. Now,
project quarterly sales for 2002. Revise quarterly sales number for
season of the year.

Winter 1998 20000 Winter 1999 22000 Winter 2000 23000 Winter 2001 23000
3 year

Winter 88000

Spring

1998 24000 Spring

1999 25000 Spring

2000 26000 Spring

2001 30000 3 year

Spring 105000

Summer 1998 35000 Summer 1999 36000 Summer 2000 37000 Summer 2001 38000
3 year

Summer 146000

Fall 1998 32000 Fall 1999 32000 Fall 2000 34000 Fall 2001 35000 3 year

Fall 133000

Total 111000

115000

120000

126000 3 year total 472000


Solution
What is this?
By OTA - Overall OTA Rating
Purchase Cost Now
$2.19 CAD (was ~$27.93)
Included in Download
  • Plain text response
  • Attached file(s):
    • 5269.xls
    • 5269.xls
$2.19 Instant Download
Add to Cart
Why you can trust BrainMass.com
  • Your Information is Secure
  • Best Online Academic Help Service
  • Students find real academic Success
Related Solutions
Browse