BUSINESS ANALYTICS Ayushi BBA -3B PPT.pptx

Its a project related PPT for Business Analytics course by NIIT

1. By- Ayushi Goel BBA 2020-23 Section-B ASB/BBA/20/048 BUSINESS ANALYTICS

2. TOOLS FOR BUSINESS ANALYTICS ( EXCEL ) DESCRIPTIVE ANALYSIS REGRESSION CO-RELATION ANOVA –ANALYSIS HISTOGRAM T - TEST SAMPLING

3. DESCRIPTIVE ANALYSIS

4. INPUT DATA Quanitity sold Price ($) Advertising ($) 8500 2 2800 4700 5 200 5800 3 400 7400 2 500 6200 5 3200 7300 3 1800 5600 4 900

5. DESCRIPTIVE ANALYSIS Quanitity sold   Price ($)   Advertising ($)   Mean 6500 Mean 3.428571429 Mean 1400 Standard Error 489.8979486 Standard Error 0.480928807 Standard Error 459.2955268 Median 6200 Median 3 Median 900 Mode #N/A Mode 2 Mode #N/A Standard Deviation 1296.14814 Standard Deviation 1.272418021 Standard Deviation 1215.181742 Sample Variance 1680000 Sample Variance 1.619047619 Sample Variance 1476666.667 Kurtosis -0.693055556 Kurtosis -1.714878893 Kurtosis -1.5141509 Skewness 0.247528291 Skewness 0.221902658 Skewness 0.65770615 Range 3800 Range 3 Range 3000 Minimum 4700 Minimum 2 Minimum 200 Maximum 8500 Maximum 5 Maximum 3200 Sum 45500 Sum 24 Sum 9800 Count 7 Count 7 Count 7

6. REGRESSION ANALYSIS

7. INPUT DATA Price ($) Quanitity sold 2 8500 5 4700 3 5800 2 7400 5 6200 3 7300 4 5600

8. REGRESSION ANALYSIS SUMMARY OUTPUT Regression Statistics Multiple R 0.808452083 R Square 0.653594771 Adjusted R Square 0.584313725 Standard Error 835.6751409 Observations 7 ANOVA   df SS MS F Significance F Regression 1 6588235.294 6588235.294 9.433962264 0.027737194 Residual 5 3491764.706 698352.9412 Total 6 10080000         Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0% Intercept 9323.529412 972.0238937 9.591872661 0.000208687 6824.862447 11822.19638 6824.86245 11822.19638 Price ($) -823.5294118 268.121751 -3.071475584 0.027737194 -1512.758315 -134.3005089 -1512.7583 -134.3005089

9. REGRESSION BY GRAPH

10. CO- RELATION ANALYSIS

11. INPUT DATA Price ($) Quanitity sold 2 8500 5 4700 3 5800 2 7400 5 6200 3 7300 4 5600

12. CO-RELATION ANALYSIS   Price ($) Quanitity sold Price ($) 1 Quanitity sold -0.8084521 1   Price ($) Quanitity sold Price ($) 1 Quanitity sold -0.8084521 1

13. ANOVA ANALYSIS

14. Input data Quanitity sold Price ($) Advertising ($) 8500 2 2800 4700 5 200 5800 3 400 7400 2 500 6200 5 3200 7300 3 1800 5600 4 900

15. ANOVA ANALYSIS Anova: Single Factor SUMMARY Groups Count Sum Average Variance Quanitity sold 7 45500 6500 1680000 Price ($) 7 24 3.428571429 1.619047619 Advertising ($) 7 9800 1400 1476666.667 ANOVA Source of Variation SS df MS F P-value F crit Between Groups 163720321.5 2 81860160.76 77.79736737 1.38555E-09 3.554557146 Within Groups 18940009.71 18 1052222.762 Total 182660331.2 20        

16. HISTOGRAM

17. Input data marks of three students A B C 157 250 156 148 140 158 150 150 145 160 185 151 167 200 166 140 140 161 154 170 156

18. HISTOGRAM

19. T – TEST

20. INPUT DATA A B 157 250 148 140 150 150 160 185 167 200 140 140 154 170

21. T test analysis t-Test: Paired Two Sample for Means   A B Mean 153.7142857 176.4285714 Variance 76.9047619 1572.619048 Observations 7 7 Pearson Correlation 0.677109052 Hypothesized Mean Difference df 6 t Stat -1.750532387 P(T<=t) one-tail 0.065297193 t Critical one-tail 1.943180281 P(T<=t) two-tail 0.130594385 t Critical two-tail 2.446911851  

22. SAMPLING

23. INPUT DATA FOR SAMPLING A B 157 250 148 140 150 150 160 185 167 200 140 140 154 170

24. RAMDOM SAMPLING Sampling 148 157 140 185 185

25. THANK YOU