business statistics
This document just discusses the zscores for datasets used in the assignment due week 10 Finding the zscores for the assignment is only part of assignment, for complete instructions to the assignment refer to the top of moodle.
Some summaries of the dataset used Section 1 of the computing assignment Including zscores The section 1 dataset consists of a population of 100,000 people split into 10,000 samples of size 10 the variables in the dataset are “income” and annual contribution to super, So you show the relationship between the variables graphically using a scatterplot and regression. You need to suppose that someone wants to predict the contribution of a person with income $200,000.
The population of 100,000 people
The scatter plot below shows the relationship between the variables
“income” and “annual contribution to savings” for 100,000 people so 100,000 points,
If income 200,000 predict annual contribution to be 27,000
Using the whole population all 100,000 points the regression line is predicted annual contribution y=0.1347*x+22 so if the predicted annual contribution is 0.1347*200,000+22=27,016
Since there are 10,000 samples there 10,000 sample predictions (estimates) for the annual contribution if income is $200,000 , The average of the 10,000 predictions (estimates) is $27,000 and the standard deviation is $2,100
Sample 700 A Sample of 10 people from a population of 100,000 people
The scatter plot below shows the relationship between the variables
“income” and “annual contribution to savings” for 10 people so 10 points,
Note that the regression line y= 0.1318x+947 goes through the middle of the points You do not have to calculate the regression line yourself, the computer does it for you The predicted contribution when income is 200,000 is predicted annual contribution =0.1318*200,000+947=27307
Since the zscore (27307-27000)/2100= 0.15 , P(Z<0.15)=0.5581 So if you compare sample 700 to the 10,000 samples then you expect rank Predicted rank = P(Z<zscore)*10000=0.5581*10,000=5581
Sample 701 Another Sample of 10 people from a population of 100,000 people
The scatter plot below shows the relationship between the variables
“income” and “annual contribution to savings” for 10 people so 10 points,
predicted annual contribution =0.142*200,000+2852=25548
Since the zscore (25548-27000)/2100= -0.69, P(Z<-0.69)=0.2446 So if you compare sample 701to the 10,000 samples then you expect rank Predicted rank = P(Z<zscore)*10000=0.2446*10,000=2446
Theory not required to do the assignment , zscores make sense if you look at the list of 10,000 estimates.
|
sample |
slope |
intercept |
predicted y for x=200000 |
zscore=(y-mean)/stdev |
actual rank lowest to highest |
|
1 |
0.1187 |
-699 |
23041 |
-1.89 |
287 |
|
|
|
|
|
|
|
|
327 |
0.1772 |
-6732 |
28708 |
0.81 |
7946 |
|
328 |
0.1085 |
3482 |
25182 |
-0.87 |
2016 |
|
329 |
0.1561 |
-3005 |
28215 |
0.58 |
7208 |
|
330 |
0.1269 |
1404 |
26784 |
-0.10 |
4675 |
|
331 |
0.1811 |
-2685 |
33535 |
3.11 |
9996 |
|
332 |
0.096 |
6064 |
25264 |
-0.83 |
2148 |
|
333 |
0.1138 |
4011 |
26771 |
-0.11 |
4648 |
|
334 |
0.1347 |
385 |
27325 |
0.15 |
5682 |
|
335 |
0.1315 |
1446 |
27746 |
0.36 |
6425 |
|
336 |
0.112 |
1530 |
23930 |
-1.46 |
774 |
|
337 |
0.1515 |
-3298 |
27002 |
0.00 |
5067 |
|
338 |
0.0955 |
5483 |
24583 |
-1.15 |
1287 |
|
|
|
|
|
|
|
|
339 |
0.1414 |
-3281 |
24999 |
-0.95 |
1784 |
|
10000 |
0.1424 |
-1142 |
27338 |
0.16 |
5705 |
For sample 331 , the sample estimate is 33535 this is clearly higher than the other estimates and it has a zscore of 3.11, its rank (lowest to highest is 9996 so it is the 99.96th percentile.
P(Z<3.11) = 0.9991 is close to the percentile but better, Since there is a list of 10,000 estimates the predicted rank is 10,000*0.9991=9991
Some summaries of the dataset used Section 2 of the computing assignment (including zscores) ( the population and some samples)
A population of 200,000 investors
|
Investment type |
Lost money |
Made money |
Total |
|
Risky investment plan (mainly shares) |
56079 |
224246 |
280325 |
|
Safer investment plan (mainly use the bank) |
11927 |
107748 |
119675 |
|
|
|
|
|
|
Investment type |
Proportion that Lost money |
Proportion that Made money |
|
Risky investment plan (mainly shares) |
=56079/280325 =0.2 =20% |
224246/280325 = 0.8 =80% |
|
Safer investment plan (mainly use the bank) |
=11927/119675 =0.0997=9.997% |
1077548/119675=0.9003 = 90.03% |
0.2
So the difference in proportions is -=0.2-0.0997=0.1003
Since there are 4000 samples you can find 4000 samples estimates of - the average is 0.1 and the standard deviation is 0.074
Sample 700 A sample of 100 people from the population of 200,000 people
|
Investment type |
Lost money |
Made money |
Total |
|
Risky investment plan (mainly shares) |
14 |
60 |
74 |
|
Safer investment plan (mainly use the bank) |
3 |
23 |
26 |
|
Investment type |
Proportion that Lost money |
Proportion that Made money |
|
Risky investment plan (mainly shares) |
=14/74 =0.1892 =18.92% |
60/74 =0.8108 =81.08% |
|
Safer investment plan (mainly use the bank) |
=3/26 =0.1154 =11.54% |
23/26=0.8846 = 88.46% |
|
|
|
|
Using the sample the estimated difference in proportions is 0.1892-0.1154=0.0738 So the zscore for that estimate is (0.0738-0.1)/0.0743=-0.35 P(Z<zscore) = P(Z<-0.35) =0.3632 So when you compare sample 700 to the 4000 other samples you predict the rank to be 0.3632*4000=1453
Sample 701 Another sample of 100 different investors from the population of 200,000 people
|
Investment type |
Lost money |
Made money |
Total |
|
Risky investment plan (mainly shares) |
16 |
58 |
74 |
|
Safer investment plan (mainly use the bank) |
4 |
22 |
26 |
|
Investment type |
Proportion that Lost money |
Proportion that Made money |
|
|
Risky investment plan (mainly shares) |
=16/74 =0.2162 =21.62% |
58/74 =0.7838 =78.38% |
|
|
Safer investment plan (mainly use the bank) |
=4/26 =0.1538 =15.38% |
22/26=0.8462 = 84.62% |
Using the sample the estimated difference in proportions is 0.2162-0.1538=0.0624 So the zscore for that estimate is (0.0624-0.1)/0.0743=-0.51
Using wolfram alpha P(Z<zscore) = P(Z<-0.51) =0.305 So when you compare sample 701 to the 4000 other samples you predict the rank to be 0.305*4000=1220
Sample 449 Another sample of 100 different investors from the population of 200,000 people
|
Investment type |
Lost money |
Made money |
Total |
|
Risky investment plan (mainly shares) |
7 |
63 |
70 |
|
Safer investment plan (mainly use the bank) |
3 |
27 |
30 |
|
Investment type |
Proportion that Lost money |
Proportion that Made money |
|
|
Risky investment plan (mainly shares) |
=7/70 =0.1 =10% |
63/70 =0.9=90% |
|
|
Safer investment plan (mainly use the bank) |
=3/30 =0.1 =10% |
27/30=0.9 = 90% |
Sample 2994 Another sample of 100 different investors from the population of 200,000 people
|
Investment type |
Lost money |
Made money |
Total |
|
Risky investment plan (mainly shares) |
7 |
63 |
70 |
|
Safer investment plan (mainly use the bank) |
6 |
24 |
30 |
|
Investment type |
Proportion that Lost money |
Proportion that Made money |
|
|
Risky investment plan (mainly shares) |
=7/70 =0.1 =10% |
63/70 =0.9=90% |
|
|
Safer investment plan (mainly use the bank) |
=3/30 =0.1 =10% |
27/30=0.80 = 80% |
Using the sample the estimated difference in proportions is 0.1-0.2=-0.1 So the zscore for that estimate is (-0-0.1)/0.0743=-2.68 Using wolfram alpha website P(Z<zscore) = P(Z<-2.68) =0.00368 So when you compare sample 2994 to the 4000 other samples you predict the rank to be 0.00368*4000=15
Theory you do not have to discuss this in the assignment
p1-p2 =0.1003 is positive
The 368 out of 4000 of the sample Estimates of p1-p2 are negative (less than 0) These samples are giving the opposite conclusion that the population , In the population the high risk investments have a higher probability of losing money however 368 of the sample make you give the opposite conclusion.
The proportion of samples that give the wrong conclusion is 368/4000=0.092
Using properties of the normal distribution , you can get a similar (but better answer) the estimates have a mean of 0.1 and standard deviation 0.0743 so an estimate of 0 has a zscore of (0-0.1)/0.0743=-1.34
P(Z<zscore) = P(Z<-1.34) = 0.09
In other words the estimate of 0 is the 9th percentile, this was found out using zscore and the normal distribution .
Some summaries of dataset used in Section 3 of the computer assignment (including zscores) ( the population and some samples )
A population of the returns of 200,000 investors
Note that return is express as a decimal, so a return of 0.05 is a return of 5%
|
Investment type |
Number of investors |
Average return |
Standard deviation |
|
Safe type (mainly use the bank) |
140209 |
µ1=0.0350 |
0.0032 |
|
Risky type (mainly use the stock market) |
59791 |
µ2=0.0606 |
0.0951 |
So the difference in population means µ1- µ2=0.035-0.606=-0.256
There are 2000 samples so you can find 2000 estimates of µ1- µ2 =-0.0256
The average of the 2000 estimates of µ1- µ2 =-0.0256 The standard deviation of the 2000 estimates µ1- µ2 =0.0173
Sample 700 One sample of the returns of 100 investors from the population of 200,000 investors
|
Investment type |
Number of investors |
Average return |
Standard deviation |
|
Safe type (mainly use the bank) |
72 |
0.0345 |
0.0028 |
|
Risky type (mainly use the stock market) |
28 |
0.0850 |
0.0849 |
So the difference in the sample means =0.0345-0.085=-0.0505 The zscore of this estimate =(-0.505- -0.0256)/ 0.0173=-1.44 using wolframalpha.com P(Z<zscore) = P(Z<-1.44)=0.075 So if you compare sample 700 to the 2000 other samples you expect it to have rank 2000*0.075=150
Sample 701 Another sample a different sample of 100 investors from the population of 200,000 investors
|
Investment type |
Number of investors |
Average return |
Standard deviation |
|
Safe type (mainly use the bank) |
67 |
0.0350 |
0.0031 |
|
Risky type (mainly use the stock market) |
33 |
0.0618 |
0.1150 |
So the difference in the sample means =0.035-0.0618=-0.0268 The zscore of this estimate =(-0.0268- -0.0256)/ 0.0173=-0.07 using wolframalpha.com P(Z<zscore) = P(Z<-0.07)=0.471 So if you compare sample 701 to the 2000 other samples you expect it to have rank 2000*0.471=942
Sample757 Another sample a different sample of 100 investors from the population of 200,000 investors
|
Investment type |
Number of investors |
Average return |
Standard deviation |
|
Safe type (mainly use the bank) |
73 |
0.0355 |
0.0031 |
|
Risky type (mainly use the stock market) |
27 |
0.0256 |
0.0942 |
So the difference in the sample means =0.0355-0.0256=0.0099 The zscore of this estimate =(0.0099 - -0.0256)/ 0.0173=2.05 using wolframalpha.com P(Z<zscore) = P(Z<2.05)=0.98 So if you compare sample 757 to the 2000 other samples you expect it to have rank 2000*0.98=1960
Sample244 Another sample a different sample of 100 investors from the population of 200,000 investors
|
Investment type |
Number of investors |
Average return |
Standard deviation |
|
Safe type (mainly use the bank) |
77 |
0.0352 |
0.0031 |
|
Risky type (mainly use the stock market) |
23 |
0.0352 |
0.0950 |
So the difference in the sample means =0.0352-0.0352=0 The zscore of this estimate =(0 - -0.0256)/ 0.0173=1.48 using wolframalpha.com P(Z<zscore) = P(Z<1.48)=0.93 So if you compare sample 244 to the 2000 other samples you expect it to have rank 2000*0.93=1860
Theory you do not have to discuss this in the assignment
µ1- µ2 =0.1 is negative
The 136 out of 2000 of the sample Estimates of µ1- µ2 are positive (less than 0) These samples are giving the opposite conclusion that the population , based on the population the risky investments have a higher average but some samples say it has a lower average
The proportion of samples that give the wrong conclusion is 136/2000=0.068
Using properties of the normal distribution , you can get a similar (but better answer) the estimates have a mean of 0.1 and standard deviation 0.0743 so an estimate of 0 has a zscore of (0-0.1)/0.0743=1.48
P(Z<zscore) = P(Z<1.48) = 0.93 so 93% of the estimates will be below 0 so the proportion and give the correct answer but 7%=0.07 will give the wrong answer.
In other words the estimate of 0 is the 93rd percentile, this was found out using zscore and the normal distribution
Some summaries of dataset used in Section 4 of the computer assignment ,including zscores ( the population and some samples )
A population of 200,000 people is asked if they support a proposed change to the Business
|
|
no |
Yes |
Total |
|
Count of do you support proposed change? |
80,000 |
120,000 |
200,000 |
population proportion of people that say yes is p=120,000/200,000=0.6
Since the sample has been split into 1000 samples there are 1000 sample estimates The average of the 1000 sample proportions is 0.6 The standard deviation of the 1000 sample proportions is 0.0357
Sample 700, A sample of 185 people are asked if they support the change. (the sample is from the population of 200,000 given above)
|
|
no |
Yes |
Total |
|
Count of do you support proposed change? |
86 |
99 |
185 |
Sample proportion of people that say yes is =99/185 =0.5351
So the zscore =(0.5351-0.6)/0.0357=-1.82 P(Z<zscore)=P(Z<-1.82)=0.0344 So if we compare sample 700 to the 1000 other estimates then we expect the rank to be 0.0344*1000=0.0344=34
Sample 701, sample of a 190 people are asked if they support the change So a different group of people (a slightly bigger sample of 190) are selected from the population of 200,000
|
|
no |
Yes |
Total |
|
Count of do you support proposed change? |
71 |
119 |
190 |
Sample proportion of people that say yes is = 119/190 =0.6263
So the zscore =(0.6263-0.6)/0.0357=0.74 P(Z<zscore)=P(Z<0.74)=0.7704 So if we compare sample 700 to the 1000 other estimates then we expect the rank to be 0.7704*1000=0.7704