logo

Calculations of Statistics and Valuation of Finances : Report

   

Added on  2020-01-07

13 Pages2091 Words229 Views
EXCEL PROJECT
Calculations of Statistics and Valuation of Finances : Report_1
TABLE OF CONTENTSQuestion 1........................................................................................................................................3Question 2........................................................................................................................................4Question 3........................................................................................................................................5Question 4......................................................................................................................................12
Calculations of Statistics and Valuation of Finances : Report_2
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
Calculations of Statistics and Valuation of Finances : Report_3
Figure 1 Histogram............................................................................................................................
Calculations of Statistics and Valuation of Finances : Report_4

End of preview

Want to access all the pages? Upload your documents or become a member.

Related Documents
Business Statistics Assignment Solved
|6
|795
|102

BUSINESS STATISTICS TABLE OF CONTENTS TABLE OF CONTENTS
|54
|6422
|171

ECON1095 Quantitative Methods In Finance
|13
|925
|171

MN4063QA Understanding and Managing Data - Desklib
|14
|1677
|203

Understanding and Managing Data: Analysis and Interpretation
|12
|1827
|53

Quantitative Methods for Business
|12
|2635
|69