This study explores data analysis and forecasting techniques, including mean, median, range, and standard deviation. It also covers linear forecasting and its application in making predictions. The importance of descriptive data analysis is highlighted.
Contribute Materials
Your contribution can guide someone’s learning journey. Share your
documents today.
Data Analysis and Forecasting
Secure Best Marks with AI Grader
Need help grading? Try our AI Grader for instant feedback on your assignments.
TABLE OF CONTENTS TABLE OF CONTENTS................................................................................................................2 REFERENCES................................................................................................................................8
INTRODUTION Data analysisand forecastingisan effectiveprocedureto analyseand effectivelymake appropriate set of predictions on the basis of present and past data and analysing the key relevant trends. This study will highlight on evaluating the wide data sets using appropriate data analysis technique. TASK 1. Creating a table for the data related to phone calls Sr. No.Date Phone calls per day 101-07-20202 202-07-20206 303-07-20205 404-07-20208 505-07-20204 606-07-20207 707-07-20209 808-07-20205 909-07-20208 1010-07-20205 2. Presentation of data for phone calls in graphical format 1
2.1 Column Chart 01-07- 202002-07- 202003-07- 202004-07- 202005-07- 202006-07- 202007-07- 202008-07- 202009-07- 202010-07- 2020 12345678910 0 1 2 3 4 5 6 7 8 9 Phone calls per day Phone calls per day 2.2 Line Chart 30/06/202002/07/202004/07/202006/07/202008/07/202010/07/202012/07/2020 0 1 2 3 4 5 6 7 8 9 10 Phone calls per dayPhone calls per day days no of phone calls 3. Mean, Median, range and standard deviation 2
Paraphrase This Document
Need a fresh take? Get an instant paraphrase of this document with our AI Paraphraser
3.1 The mean Mean is significantly used to find the average value associated with the specific data sets in statistics. It helps in analysing and make appropriate decision (SEPTIO A, 2015). Sr. No.Date Phone calls per day 101-07-20202 202-07-20206 303-07-20205 404-07-20208 505-07-20204 606-07-20207 707-07-20209 808-07-20205 909-07-20208 1010-07-20205 Sum total of phone calls59 No. of observation10 Mean5.9 Within the above data mean is calculated by the sum of observation which is further divided by the number of data observed. It helps in examining the average happening of the value within the given set of data. Mean in the data for phone calls is 5.9. 3.2 The Median This is referred to as a simple measure associated with the central tendency. It helps in arranging the observations within the specific order. In case of odd number of observation the median is considered to be as the median value. In case of even number the median is considered to be as the average of the 2 values of observation. Sr. No.Date Data in relation to phone calls per day 101-07-20202 202-07-20206 303-07-20205 404-07-20208 505-07-20204 3
606-07-20207 707-07-20209 808-07-20205 909-07-20208 1010-07-20205 No. of observation59 M=(10+1)/25.5 M=(4+7)/25.5 Median for phone calls in a day is computed by averaging the mid- values which are values of the day 5thand 6ththat are 4 and 7 respectively. Upon averaging these two values the mid value is calculated as 5.5. 3.3 The Mode It is considered to be as the specific set of value which tends to occur the most number of times within the specific data set (Nowakowski, 2020). Date Phone calls per day 01-07-20202 02-07-20206 03-07-20205 04-07-20208 05-07-20204 06-07-20207 07-07-20209 08-07-20205 09-07-20208 10-07-20205 Mode =5 The mode of the specific data sets is 5 which tends to shows that, in the duration of 10 days the specific user has received 5 calls 3 times a day. 3.4 The Range Range within statistics is considered to be as a method which helps in examining the variance between the minimum value and maximum value within the data sets. 4
ParticularsFormulaAmount Maximum9 Minimum2 Range Largest value-Smallest value7 Range of the specific call is considered to be 7 because the highest value is amounted to be 9 and moreover the lowest value is amounted to be 2. However, the difference between the two values is 7. 3.5 The standard deviation It helps in examining the variance of the specific outcomes associated with the mean value (Peleg, 2019). DatePhone calls (X)X^2 01-07-202024 02-07-2020636 03-07-2020525 04-07-2020864 05-07-2020416 06-07-2020749 07-07-2020981 08-07-2020525 09-07-2020864 10-07-2020525 Total59389 Standard deviation= Square root of ∑x^2 / N – (∑x / n) ^ 2 SQRT of (389 / 59) – (59 / 10) ^ 2 SQRT of 6.59 – 34.81 SQRT of -28.22 5.31 Standard deviation of this given observation is estimated to be 5.31 which in turn is not considered to be very high. However, the spreading from the value of mean is less. 4 Linear Forecasting DateX Phone calls (Y)X*YX^2 01-07-20201221 02-07-202026124 03-07-202035159 5
Secure Best Marks with AI Grader
Need help grading? Try our AI Grader for instant feedback on your assignments.
04-07-2020483216 05-07-2020542025 06-07-2020674236 07-07-2020796349 08-07-2020854064 09-07-2020987281 10-07-202010550100 Total5559348385 4.1 “m” value m = NΣxy – Σx Σy / NΣ x^2 – (Σx)^2 m = 10 (348) - (55 * 59) / (10 * 385) – (55)^2 m = (3480 – 3245) / (3850 – 3025) m = 235/ 825 m = 0.28 4.2 “c” value c = Σy – m Σx / N c = 59 – (0.28 * 55) / 10 c = (59 – 15.4) / 10 c = 43.6 / 10 c = 4.36 4.3 Day 12 Forecasting Y = mX + c = 0.28 * (12) + (4.36) = 3.36 + 4.73 =8.09 = 8 calls approx 4.4 Day 14 Forecasting Y = mX + c = 0.28 * (14) + (4.36) = 3.92 + 4.36 =8.28 = 8 calls approx 6
It could be analysed that using the linear forecasting, forecast for calls on 12thand 14th day is 8. The analysis is used by the researchers for making forecast of the future outcomes. This is an effective method used in statistics for drawing results and framing accurate conclusions. CONCLUSION It could be concluded from the above study about descriptive data analysis that it plays an important role in analysis of the data. Report has increased the practical understanding about the use of different method in statistics. 7
REFERENCES Books and Journals Nowakowski, S., 2020. Uniqueness of a Median of a Binomial Distribution with Rational Probability.arXiv preprint arXiv:2004.03280. Peleg, M., 2019. Beta distributions for particle size having a finite range and predetermined mode, mean or median.Powder Technology,356, pp.790-794. SEPTIO A, A.L.B.E.R.T.U.S., 2015.Statistical Calculation of Mean, Median, Mode, and Standard Deviation Using PHP programming language(Doctoral dissertation, Prodi Teknik Informatika Unika Soegijapranata). 8