Statistics Solution Assignment
Added on 2021-02-21
21 Pages2421 Words84 Views
STATISTICS
TABLE OF CONTENTSINTRODUCTION...........................................................................................................................1TASK 1............................................................................................................................................1a) Determining difference in earnings of men and women in public sector using hypothesistests .............................................................................................................................................1b) Determining difference in earnings of men and women in private sector using hypothesistests..............................................................................................................................................2c) Earning time charts for each group..........................................................................................3d) Determining annual growth rate in earnings using chart.........................................................4TASK 2............................................................................................................................................5a) Evaluation and analysis of Hourly pay rates ..........................................................................5b) Comparing earnings among two regions.................................................................................7TASK 3............................................................................................................................................7Section A .....................................................................................................................................7Section B .....................................................................................................................................8TASK 4............................................................................................................................................84.1 Representing data using charts and tables.............................................................................84.2 Evaluation of average prices in 2 and 3 bedrooms over three streets..................................13CONCLUSION..............................................................................................................................17REFERENCES..............................................................................................................................18
INTRODUCTIONStatistics is concerned with collecting, organizing, analysis, display presentation andinterpretation of data. Statistical analysis refers to data analysis that in business intelligence isused for analysing and collecting data samples from which samples can be derived (Searle andKhuri, 2017). Report will cover the analysis for evaluating data from different sources, and foranalysing the quantitative raw business data using statistical methods. The explanations would begiven using appropriate tables, charts and variable findings for better understandings. TASK 1a) Determining difference in earnings of men and women in public sector using hypothesis tests Null Hypothesis : There is no significant difference between men and women income in publicsector.Alternate Hypothesis : There is significant difference between men and women income inpublic sector.t-Test: Two-Sample Assuming EqualVariancesMen earnings inpublic sectorWomen earnings inpublic sectorMean32276.62526933.25Variance1449962.26785714975692.5Observations88Pooled Variance1212827.38392857Hypothesized Mean Difference0df14t Stat9.7038964331P(T<=t) one-tail6.76878422104249E-008t Critical one-tail1.7613101358P(T<=t) two-tail1.3537568442085E-007t Critical two-tail2.14478668791
InterpretationFrom the two tail test value of probability is more than 0.05 i.e. 1.35 which shows there isno significant difference theretofore the null hypothesis is accepted.b) Determining difference in earnings of men and women in private sector using hypothesis tests.Null Hypothesis: There is no significant difference between men and women income in privatesector.Alternate Hypothesis:There is significant difference between men and women income inprivate sector.t-Test: Two-Sample Assuming EqualVariancesMen earnings inprivate sectorWomen earnings inprivate sectorMean28096.62520541.25Variance795287.696428572988729.928571429Observations88Pooled Variance892008.8125Hypothesized Mean Difference0df14t Stat15.9993171714P(T<=t) one-tail1.08089238375977E-010t Critical one-tail1.7613101358P(T<=t) two-tail2.16178476751954E-010t Critical two-tail2.14478668792
Interpretation Applying the two tail tests of probability over the private data it is identified that probability ismore than 0.05 i.e. 2.16 theretofore there is no significant difference between income of men andwomen and null hypothesis is accepted.c) Earning time charts for each groupPublic sector YearMen public sectorWomen public sector20093063825224201031264261132011313802647020123181626663201332541273382014328782770520153368527900201634011280533123456780500010000150002000025000300003500040000YearMen public sectorWomen public sector
Private sector YearMen private sectorWomen private sector2009276321955120102700019532201127233195652012277052031320132820120698201428442210172015288812140320162967922251d) Determining annual growth rate in earnings using chart.PUBLIC SECTOR ANNUAL GROWTH RATE YearMen publicsectorYOY GrowthrateWomen publicsectorYOY Growthrate200930638252242010312642%261134%2011313800%264701%41234567805000100001500020000250003000035000YearMen private sectorWomen private sector
End of preview
Want to access all the pages? Upload your documents or become a member.
Related Documents
Statistics for Management INTRODUCTION 2 MAIN BODY2 TASK 12 B. Analysis and evaluatiolg...
|27
|3973
|312
Statistics Financial in UKlg...
|28
|4065
|51
Statics Financial Induced Decisionlg...
|20
|3378
|379
Statistical Analysis of Management Payslg...
|18
|3592
|347
Statistics for Management Assignment Reportlg...
|23
|5182
|42
Assignment Statistics for Managementlg...
|22
|4725
|101