Calculations of Statistics and Valuation of Finances : Report
Added on 2020-01-07
13 Pages2091 Words229 Views
EXCEL PROJECT
TABLE OF CONTENTSQuestion 1........................................................................................................................................3Question 2........................................................................................................................................4Question 3........................................................................................................................................5Question 4......................................................................................................................................12
Table 1 raw calculation for descriptive statistics.........................................................................................5Table 2: Calculation of median....................................................................................................................5Table 3: t-Test: Two-Sample Assuming Unequal Variances.......................................................................7Table 4: F-Test Two-Sample for Variances.................................................................................................8Table 5: Regression analysis.......................................................................................................................9Table 6: ANNOVA table.............................................................................................................................9Table 7: Coefficient table............................................................................................................................9Table 8: Regression analysis.....................................................................................................................10Table 9: ANNOVA table...........................................................................................................................10Table 10: Coefficient table........................................................................................................................10Table 11: Regression table........................................................................................................................11Table 12: ANNOVA table.........................................................................................................................11Table 13: Coefficient table........................................................................................................................11Table 14: Regression table........................................................................................................................11Table 15: ANNOVA table.........................................................................................................................12Table 16: Table of coefficients..................................................................................................................12Table 17: Regression table........................................................................................................................13Table 18: ANNOVA table.........................................................................................................................13Table 19: Table of coefficient....................................................................................................................13Table 20: Regression table........................................................................................................................14Table 21: ANNOVA table.........................................................................................................................14Table 22: Coefficient table........................................................................................................................14Table 23: Average and variance table........................................................................................................15Table 24: ANNOVA table.........................................................................................................................15List of figures
Figure 1 Histogram............................................................................................................................
End of preview
Want to access all the pages? Upload your documents or become a member.
Related Documents
Business Statistics Assignment Solvedlg...
|6
|795
|102
BUSINESS STATISTICS TABLE OF CONTENTS TABLE OF CONTENTSlg...
|54
|6422
|171
ECON1095 Quantitative Methods In Financelg...
|13
|925
|171
MN4063QA Understanding and Managing Data - Deskliblg...
|14
|1677
|203
Understanding and Managing Data: Analysis and Interpretationlg...
|12
|1827
|53
Quantitative Methods for Businesslg...
|12
|2635
|69