Team b wk 6
Download as PPTX, PDF
0 likes79 views
The document contains monthly seasonal indices of total net collections for California businesses from 2008 to 2014. It includes the monthly amounts in millions of dollars for each year, as well as statistical measures like mean, median, mode, standard deviation, minimum, maximum and range. The purpose is for data analysis in business intelligence, confirmation of hypotheses, forecasting, and helping allocate resources and identify changes. Questions are welcome.
Team b wk 6
- 1. Team B QRB/501 Prof. Scott Hannum
- 3. 9 8 7 6 2008 2009 5 2010 2011 4 2012 3 2013 2014 2 1 0 January February March April May June July August September October November December Monthly Seasonal Indices of Total Net for California Business Bureau Collector Statistics
- 5. In millions 2008 2009 2010 2011 2012 2013 2014 January 1.9 1.8 2.8 2.5 2.7 $2.84 $2.98 February 3.4 1.3 4.5 1.6 4.8 $5.04 $5.29 March 1 2.8 8 3.1 1.4 $1.47 $1.54 April 3.2 1.7 3.7 1.7 4.6 $4.83 $5.07 May 1.8 1.2 2.6 3.4 1.4 $1.47 $1.54 June 1.6 3.8 2.9 2.3 2.3 $2.42 $2.54 July 1.6 1.8 2.9 2.4 2.3 $2.42 $2.54 August 1.8 2.4 3 3.9 1.4 $1.47 $1.54 September 0.5 5.5 3.9 3.5 0.7 $0.74 $0.77 October 1.9 0.9 3.1 2.3 2.7 $2.84 $2.98 November 1.1 2.7 4.2 2.2 1.6 $1.68 $1.76 December 1 0.8 3 0.8 1.4 $1.47 $1.54 Mean 1.733 2.225 3.717 2.475 2.275 2.389 2.508 Median 1.7 1.8 3.05 2.35 1.95 2.0475 2.149875 Mode 1.9 1.8 2.9 2.3 1.4 1.47 1.5435 Monthly Seasonal Indices of Total Net for California Business Bureau Collector Statistics
- 7. In millions 2008 2009 2010 2011 2012 2013 2014 January 1.9 1.8 2.8 2.5 2.7 $2.84 $2.98 February 3.4 1.3 4.5 1.6 4.8 $5.04 $5.29 March 1 2.8 8 3.1 1.4 $1.47 $1.54 April 3.2 1.7 3.7 1.7 4.6 $4.83 $5.07 May 1.8 1.2 2.6 3.4 1.4 $1.47 $1.54 June 1.6 3.8 2.9 2.3 2.3 $2.42 $2.54 July 1.6 1.8 2.9 2.4 2.3 $2.42 $2.54 August 1.8 2.4 3 3.9 1.4 $1.47 $1.54 September 0.5 5.5 3.9 3.5 0.7 $0.74 $0.77 October 1.9 0.9 3.1 2.3 2.7 $2.84 $2.98 November 1.1 2.7 4.2 2.2 1.6 $1.68 $1.76 December 1 0.8 3 0.8 1.4 $1.47 $1.54 Std Dev 0.854 1.353 1.479 0.886 1.284 1.348 1.416 Min 0.5 0.8 2.6 0.8 0.7 0.735 0.77175 Max 3.4 5.5 8 3.9 4.8 5.04 5.292 Range 2.9 4.7 5.4 3.1 4.1 4.305 4.52025 Monthly Seasonal Indices of Total Net for California Business Bureau Collector Statistics(Table 1)
- 10. Millions of Dollars 6 8 0 1 2 3 4 5 7 9 Ja Table 1 nu ar Fe y br ua ry M ar ch Ap r il M ay Ju ne Ju ly Au gu Se st pt em be r Oc to No ber Ammounts Assigned ve m be De r ce m be r 2012 2011 2010 2009 2008
- 12. Data analysis is a part of the business intelligence Confirmation of a hypothesis Forecasting
- 13. Helps properly allocate resources (employees, time, money) Helps identify if any changes can be made and where they can be made Facilitates incremental changes
- 14. Well happily address any questions! THANK YOU!
Editor's Notes
- #8: This frequency distribution of the FY 2012 shows how the most frequent amount assigned for collection was $4.6 million.
- #9: The billing and collection department of a major hospital has provided 4 years worth of data. This data shows the amount of medical debt each collection agent has assigned to him or her throughout the different months of the years in millions of dollars. Data covering the years 2008 through 2011 are provided. The data for the year 2012 is forecasted using the Consumer Price Index (CPI) for medical care services for the selected years. The CPI for medical care services in 2008 is 2.6 (Bureau of Labor and Statistics, n.d.) and this is the number used to forecast the amounts assigned to collection agents in 2012, where the CPI is 3.7. According to the forecast, 2012 will have many of the same peaks, valleys, and plateaus seen in 2008. The main difference between the two years is the plateau forecasted for the months of May, June and July of 2012 rise much higher than the plateau seen in the same months in 2008.