Healthcare claims using the ratio-to- moving-average method

Reference no: EM13990592

The following table represents the quarterly value of healthcare claims (in R millions) against all medical health schemes for the period 2007 to 2010.

Year	Quarter 1	Quarter 2	Quarter 3	Quarter 4
2007	11.8	13.2	19.1	16.4
2008	10.9	12.4	22.4	17.8
2009	12.2	16.2	24.1	14.6
2010	12.8	14.5	20.8	16.1

(a) Calculate quarterly seasonal indexes for healthcare claims using the ratio-to- moving-average method.

(b) Derive a trendline using the method of least squares.

(d) Use Excel's Line with Marker option from the Insert > Chart tab to plot the actual healthcare claims values and the seasonally adjusted trend estimates of healthcare claims values.

Reference no: EM13990592

Questions Cloud

What was the outcome of this change situation : Resistance to change is more likely to succeed if the forces resisting the change are stronger than the forces driving the need for change. Describe some of the specific tactics that resisters could employ to thwart change efforts.

Describe the cultural differences in international business : Describe the Cultural differences in international business environments. What is the role of culture in the management of diversity and communicate across cultures. Discuss the keys for successful international management. Discussion should be appro..

Prepare a performance report for april that can be used : Prepare a performance report for April that can be used to judge Paragon's success or failure in meeting budgeted targets. Comment on your findings.

Healthcare claims using the ratio-to- moving-average method : (a) Calculate quarterly seasonal indexes for healthcare claims using the ratio-to- moving-average method. (b) Derive a trendline using the method of least squares. (c) Estimate the seasonally adjusted trend value of healthcare claims for each quarter..

Original data series and the de-seasonalised data : (a) Remove the influence of seasonal factors on the number of visitors to the Addo National Park for each of the periods from 2008 to 2010. (b) Plot both the original data series and the de-seasonalised data series of the number of visitors to the..

Analyze data and explain which would be better medication : A cold and flu study is looking at how two different medications work on sore throats and fever. Analyze the data and explain which one would be the better medication for both a sore throat and a fever

Problem regarding the price of the netron share : A share trader has a policy of selling a share if its share price drops more than one-third of its purchase price. In January, the investor bought shares in Netron (an electronics company) for 90c per share. The table below shows the price of the ..

The main purpose of the book : State as accurately as possible the author's purpose for writing the book. In other words, what motivated him/her to write it, what did he/she hope to accomplish? A strong answer will require several sentences.]

User Account

All Pages