Have two homework problems that I need drastic help on. Just don\'t get it. Than
ID: 403694 • Letter: H
Question
Have two homework problems that I need drastic help on. Just don't get it. Thanks -The following data was taken from an auto parts house that is open only 5 days a week. As you can see the data does not exhibit any uphill or downhill trend. Using the simple averaging technique, compute season relatives for each day of the week.
Observation Day of the Week Sales (thousands) Observation Day of the Week Sales (thousands) 1 Mon 30 16 Mon 32 2 Tue 37 17 Tue 31 3 Wed 44 18 Wed 47 4 Thur 30 19 Thur 32 5 Fri 22 20 Fri 25 6 Mon 33 21 Mon 25 7 Tue 34 22 Tue 38 8 Wed 46 23 Wed 41 9 Thur 34 24 Thur 36 10 Fri 26 25 Fri 30 11 Mon 30 26 Mon 28 12 Tue 35 27 Tue 37 13 Wed 44 28 Wed 44 14 Thur 32 29 Thur 28 15 Fri 25 30 Fri 24
Season Relatives:
Monday =
Tuesday =
Wednesday =
Thursday =
Friday =
Format your answer as X.XX Examples: .94 would be written as 0.94 and 1.3 would be written as 1.30 Have two homework problems that I need drastic help on. Just don't get it. Thanks - Have two homework problems that I need drastic help on. Just don't get it. Thanks -
The following data was taken from an auto parts house that is open only 5 days a week. As you can see the data does not exhibit any uphill or downhill trend. Using the simple averaging technique, compute season relatives for each day of the week.
Observation Day of the Week Sales (thousands) Observation Day of the Week Sales (thousands) 1 Mon 30 16 Mon 32 2 Tue 37 17 Tue 31 3 Wed 44 18 Wed 47 4 Thur 30 19 Thur 32 5 Fri 22 20 Fri 25 6 Mon 33 21 Mon 25 7 Tue 34 22 Tue 38 8 Wed 46 23 Wed 41 9 Thur 34 24 Thur 36 10 Fri 26 25 Fri 30 11 Mon 30 26 Mon 28 12 Tue 35 27 Tue 37 13 Wed 44 28 Wed 44 14 Thur 32 29 Thur 28 15 Fri 25 30 Fri 24
Season Relatives:
Monday =
Observation Day of the Week Sales (thousands) Observation Day of the Week Sales (thousands) 1 Mon 30 16 Mon 32 2 Tue 37 17 Tue 31 3 Wed 44 18 Wed 47 4 Thur 30 19 Thur 32 5 Fri 22 20 Fri 25 6 Mon 33 21 Mon 25 7 Tue 34 22 Tue 38 8 Wed 46 23 Wed 41 9 Thur 34 24 Thur 36 10 Fri 26 25 Fri 30 11 Mon 30 26 Mon 28 12 Tue 35 27 Tue 37 13 Wed 44 28 Wed 44 14 Thur 32 29 Thur 28 15 Fri 25 30 Fri 24
Tuesday =
Wednesday =
Thursday =
Friday =
Format your answer as X.XX Examples: .94 would be written as 0.94 and 1.3 would be written as 1.30 Observation Day of the Week Sales (thousands) Observation Day of the Week Sales (thousands) 1 Mon 30 16 Mon 32 2 Tue 37 17 Tue 31 3 Wed 44 18 Wed 47 4 Thur 30 19 Thur 32 5 Fri 22 20 Fri 25 6 Mon 33 21 Mon 25 7 Tue 34 22 Tue 38 8 Wed 46 23 Wed 41 9 Thur 34 24 Thur 36 10 Fri 26 25 Fri 30 11 Mon 30 26 Mon 28 12 Tue 35 27 Tue 37 13 Wed 44 28 Wed 44 14 Thur 32 29 Thur 28 15 Fri 25 30 Fri 24
Explanation / Answer
with proper arranging of given data
1 Mon 30
6 Mon 33
11 Mon 30
16 Mon 32
21 Mon 25
26 Mon 28
Average value of Monday=(30+33+30+32+25+28)/6=29.66
2 Tue 37
17 Tue 31
7 Tue 34
22 Tue 38
12 Tue 35
27 Tue 37
Average value of Tuesday=(37+31+34+38+35+37)/6=35.33
3 Wed 44
18 Wed 47
8 Wed 46
23 Wed 41
13 Wed 44
28 Wed 44
Averge value of Wednesday=44.33
4 Thur 30
19 Thur 32
9 Thur 34
24 Thur 36
14 Thur 32
29 Thur 28
Average value of Thursday=32
5 Fri 22
20 Fri 25
10 Fri 26
25 Fri 30
15 Fri 25
30 Fri 24
Average value of friday=25.33
total=29.66+35.33+44.33+32+25.33=166.65
Average is=166.65/5=33.33
seasonal relative for monday wrt average is =29.66/33.33=0.88
seasonal relative for Tuesday wrt average is =35.33/33.33=1.06
seasonal relative for Wednesday wrt average is =44.33/33.33=1.33
seasonal relative for Thursday wrt average is =32/33.33=0.96
seasonal relative for Friday wrt average is =25.33/33.33=0.76
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.