Question

The appliance shop sells a variety of electronic equipment and home appliance. For the last four...

The appliance shop sells a variety of electronic equipment and home appliance. For the last four years the following quarterly sales (in $ millions) were reported

Quarter
Year I II III IV
2008 5.3 4.1 6.8 6.7
2009 4.8 3.8 5.6 6.8
2010 4.3 3.8 5.7 6.0
2011 5.6 4.6 6.4 5.9

Determine a typical seasonal index for each of the four quarters.( Please do not use excel. Do manual calculations with proper working by using table only)

Math   Statistics-And-Probability   
0 0
Add a commentTranscribed image text
Next >

Homework Answers

Answer #1

Find the average each quarter

Q1 = (5.3+4.8+4.3+5.6)/4 = 5
Q2 = (4.1+3.8+3.8+4.6)/4 = 4.075
Q3 = (6.8+5.6+5.7+6.4)/4 = 6.125
Q4 = (6.7+6.8+6+5.9)/4 = 6.35

Find the average of the total

Total = (5 + 4.075 + 6.125 + 6.35)/4 = 5.3875

The seasonality index is obtained by dividing Quarter average with total average

Quarter       Index
Q1 = 5/5.3875 = 0.9280
Q2 = 4.075/5.3875 = 0.7563
Q3 = 6.125/5.3875 = 1.1368
Q4 = 6.35/5.3875 = 1.1786

0 0
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Use the data in Bank Dataset to answer this question. Construct a 95% confidence interval for...
Use the data in Bank Dataset to answer this question. Construct a 95% confidence interval for the mean increase in deposits. Note that the population standard deviation σ is not known in this case. Instead the sample standard deviation s should be calculated from the sample and the t distribution should be used. 2. What is the margin of error at the 95% confidence level? Bank Dataset of Increase in deposits. Mean is 4. Sample size is 152 customers. 4.3...
We wish to determine the impact of Specification Buying, X11, on Satisfaction Level, X10. To do...
We wish to determine the impact of Specification Buying, X11, on Satisfaction Level, X10. To do so we will split the Hatco data file into two separate data sets based on the Specification Buying, X11. This variable has two categories: 1=employs total value analysis approach, evaluating each purchase separately; 0 = use of specification buying. Sort the entire Hatco data set based on Specification Buying. This will create two separate groups of records. Those records with X11 = 0 and...
An important statistical measurement in service facilities (such as restaurants and banks) is the variability in...
An important statistical measurement in service facilities (such as restaurants and banks) is the variability in service times. As an experiment, two bank tellers were observed, and the service times for each of 100 customers were recorded. Do these data allow us to infer at the 5% significance level that the variance in service times differs between the two tellers? Estimate with 95% confidence the ratio of variances of the two bank tellers. Teller 1 Teller 2 7.2 10.9 5.4...
Estimate the following simple regression models (using the given data) Male Labor Participation = β0 +...
Estimate the following simple regression models (using the given data) Male Labor Participation = β0 + β1*Average Hourly Earnings + ei Female Labor Participation = β0 + β1*Average Hourly Earnings + ei Interpret the estimated parameters of the above two regression models Year CLFPRM CLFPRF UNRM UNRF AHE 1980 77.4 51.5 6.9 7.4 6.8 1981 77.0 52.1 7.4 7.9 7.4 1982 76.6 52.6 9.9 9.4 7.9 1983 76.4 52.9 9.9 9.2 8.2 1984 76.4 53.6 7.4 7.6 8.5 1985 76.3...
Med Student Sleep Average (Raw Data, Software Required): Here we consider a small study on the...
Med Student Sleep Average (Raw Data, Software Required): Here we consider a small study on the sleep habits of med students and non-med students. The study consists of the hours of sleep per night obtained from 30 non-med students and 25 med students. The sample data is given in the table below. Test the claim that, on average, the mean hours of sleep for all med students is different from that for non-med students. Test this claim at the 0.05...
Year Unemployment rate gdp growth cpi inflation rate 1980 7.2 -0.2 87 1981 7.6 2.6 94...
Year Unemployment rate gdp growth cpi inflation rate 1980 7.2 -0.2 87 1981 7.6 2.6 94 8.05 1982 9.7 -1.9 97.6 3.83 1983 9.6 4.6 101.3 3.79 1984 7.5 7.3 105.3 3.95 1985 7.2 4.2 109.3 3.80 1986 7.0 3.5 110.5 1.10 1987 6.2 3.5 115.4 4.43 1988 5.5 4.2 120.5 4.42 1989 5.3 3.7 126.1 4.65 1990 5.6 1.9 133.8 6.11 1991 6.9 -0.1 137.9 3.06 1992 7.5 3.6 141.9 2.90 1993 6.9 2.7 145.8 2.75 1994 6.1 4.0...
Experiment 1: Titrations With Hot Taco Sauce and Ketchup Materials: (2) 250 mL Beakers 100 mL...
Experiment 1: Titrations With Hot Taco Sauce and Ketchup Materials: (2) 250 mL Beakers 100 mL Beaker (waste beaker) 30 mL Syringe Syringe stopcock 100 mL Graduated cylinder Funnel Stir rod Ring stand Ring Clamp pH meter Scale 20 mL 0.1M NaOH 2 Ketchup packets 2 Hot sauce packets *90 mL Distilled water *Scissors *Computer Access *Access to a Graphing Software *Procedure for creating this solution provided in the "Before You Begin..." section (located at the beginning of the manual)....
To measure profitability, La Quinta used operating margin, which is the ratio of the sum profit,...
To measure profitability, La Quinta used operating margin, which is the ratio of the sum profit, depreciation, and interest expenses divided by total revenue. The ratio is expressed in percent form, meaning that it could theoretically take on any value between 0 and 100, with a higher value indicating greater profitability. La Quinta defines profitable inns as those with an operating margin in excess of 50 percent; unprofitable inns are those with margins of less than 30 percent. After a...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT