# (solved) Statistics Assignment

Added on -2020-07-22

| 18 pages| 1639 words| 123 views

Trusted by 2+ million users,
1000+ happy students everyday

### Showing pages 1 to 4 of 18 pages

Statistics
TABLE OF CONTENTSSECTION 1.....................................................................................................................................1a. Presenting scatter plot on the basis of given data set...............................................................1b. Estimating annual contribution if income is \$200,000............................................................1c. Finding Z score........................................................................................................................1d. Assessing P(Z < zscore)...........................................................................................................2e. Ranking....................................................................................................................................2SECTION 2.....................................................................................................................................3a. Pivot table by using excel........................................................................................................3b. Graphical presentation.............................................................................................................4c. Commenting on the relationship takes place between the two variables.................................4d...................................................................................................................................................41. Stating the deviations take place in the sample proportion.....................................................42. Assessing the value of Z score.................................................................................................43. Determining P(Z<zscore)........................................................................................................54. Give ranking on the basis of estimation..................................................................................5e. Testing there is a difference in the proportions @ 5% level of significance...........................61. Stating hypothesis....................................................................................................................62. Finding p value........................................................................................................................63. Stating whether null hypothesis is true or false.......................................................................74. Conclusion...............................................................................................................................8SECTION 3.....................................................................................................................................8a. Creating a pivot table for summarizing statistical information...............................................8b. Creating appropriate graph to show the relationship between the variables...........................8c. Commenting on the relationship between the variables..........................................................9
d...................................................................................................................................................91. Difference between the sample means x1-x2.........................................................................92. Z-score.....................................................................................................................................93.................................................................................................................................................104.................................................................................................................................................10e. Testing significant differences in the mean value @ 5% level of significance.....................111. Hypothesis.............................................................................................................................112.................................................................................................................................................113.................................................................................................................................................114.................................................................................................................................................11SECTION 4...................................................................................................................................12a..................................................................................................................................................12b.................................................................................................................................................12c. Assessing Z score...................................................................................................................121.................................................................................................................................................122.................................................................................................................................................123. Ranking..................................................................................................................................13d. Finding 95% confidence interval level for the people who support change..........................13SECTION 5...................................................................................................................................14A and c Creating or obtaining own data set...............................................................................14b. Summarizing variables by using pivot table..........................................................................14SECTION 6...................................................................................................................................15Discussing the manner in which mean and standard deviations are used in finance.................15
SECTION 1a. Presenting scatter plot on the basis of given data set 5000010000015000020000025000030000035000005000100001500020000250003000035000400004500050000f(x) = 0.16 x − 2937.26R² = 0.94Scatter plot of income and contribution b. Estimating annual contribution if income is \$200,000Y = .158x – 2937Y =.158*200000 – 2937Y = 31600 – 2937= 28663c. Finding Z score Raw score28663Population mean27000Standard deviation2100Z score (X - μ) / SD(28663 – 27000) / 2100 = .7919

## Found this document preview useful?

You are reading a preview
Upload your documents to download
or
Become a Desklib member to get accesss

## Students who viewed this

### Follow Us

©2023 | A2Z Pte.Ltd. | All rights reserved.