Spreadsheet: 61366d1262183115-how-does-one-set-up-a-probit-model-book1
Sheet: model

SUMMARY OUTPUT
Regression Statistics
Multiple R | 0.7251684944502917
R Square | 0.5258693453433028
Adjusted R Square | 0.5186751007389863
Standard Error | 0.4886418251442984
Observations | 140
ANOVA
 | df | SS | MS | F | [NAME]
Regression | 1 | 36.81085417403119 | 36.81085417403119 | 154.1681354808105 | 3.092351355214722e-24
Residual | 139 | 33.18914582596881 | 0.2387708332803511
Total | 140 | 70
 | Coefficients | Standard Error | t Stat | P-value | Lower 95% | Upper 95% | Lower 95.0% | Upper 95.0%
Intercept | 0 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
X | 0.5927036257897166 | 0.04773536789007007 | 12.41644616952897 | 2.763066880686094e-24 | 0.4983223211587364 | 0.6870849304206967 | 0.4983223211587364 | 0.6870849304206967
PROBABILITY OUTPUT
Percentile | Y
0.3571428571428572 | 0
1.071428571428571 | 0
1.785714285714286 | 0
2.5 | 0
3.214285714285714 | 0
3.928571428571429 | 0
4.642857142857142 | 0
5.357142857142857 | 0
6.071428571428571 | 0
6.785714285714286 | 0
7.5 | 0
8.214285714285715 | 0
8.928571428571429 | 0
9.642857142857144 | 0
10.35714285714286 | 0
11.07142857142857 | 0
11.78571428571429 | 0
12.5 | 0
13.21428571428572 | 0
13.92857142857143 | 0
14.64285714285714 | 0
15.35714285714286 | 0
16.07142857142857 | 0
16.78571428571429 | 0
17.5 | 0
18.21428571428572 | 0
18.92857142857143 | 0
19.64285714285714 | 0
20.35714285714286 | 0
21.07142857142857 | 0
21.78571428571429 | 0
22.5 | 0
23.21428571428572 | 0
23.92857142857143 | 0
24.64285714285714 | 0
25.35714285714286 | 0
26.07142857142857 | 0
26.78571428571429 | 0
27.5 | 0
28.21428571428572 | 0
28.92857142857143 | 0
29.64285714285714 | 0
30.35714285714286 | 0
31.07142857142857 | 0
31.78571428571429 | 0
32.5 | 0
33.21428571428572 | 0
33.92857142857142 | 0
34.64285714285714 | 0
35.35714285714285 | 0
36.07142857142857 | 0
36.78571428571428 | 0
37.5 | 0
38.21428571428572 | 0
38.92857142857142 | 0
39.64285714285714 | 0
40.35714285714285 | 0
41.07142857142857 | 0
41.78571428571428 | 0
42.5 | 0
43.21428571428572 | 0
43.92857142857142 | 0
44.64285714285714 | 0
45.35714285714285 | 0
46.07142857142857 | 0
46.78571428571428 | 0
47.5 | 0
48.21428571428572 | 0
48.92857142857142 | 0
49.64285714285714 | 0
50.35714285714285 | 1
51.07142857142857 | 1
51.78571428571428 | 1
52.5 | 1
53.21428571428572 | 1
53.92857142857142 | 1
54.64285714285714 | 1
55.35714285714285 | 1
56.07142857142857 | 1
56.78571428571428 | 1
57.5 | 1
58.21428571428572 | 1
58.92857142857142 | 1
59.64285714285714 | 1
60.35714285714285 | 1
61.07142857142857 | 1
61.78571428571428 | 1
62.5 | 1
63.21428571428572 | 1
63.92857142857142 | 1
64.64285714285715 | 1
65.35714285714286 | 1
66.07142857142858 | 1
66.78571428571429 | 1
67.5 | 1
68.21428571428572 | 1
68.92857142857143 | 1
69.64285714285715 | 1
70.35714285714286 | 1
71.07142857142858 | 1
71.78571428571429 | 1
72.5 | 1
73.21428571428572 | 1
73.92857142857143 | 1
74.64285714285715 | 1
75.35714285714286 | 1
76.07142857142858 | 1
76.78571428571429 | 1
77.5 | 1
78.21428571428572 | 1
78.92857142857143 | 1
79.64285714285715 | 1
80.35714285714286 | 1
81.07142857142858 | 1
81.78571428571429 | 1
82.5 | 1
83.21428571428572 | 1
83.92857142857143 | 1
84.64285714285715 | 1
85.35714285714286 | 1
86.07142857142858 | 1
86.78571428571429 | 1
87.5 | 1
88.21428571428572 | 1
88.92857142857143 | 1
89.64285714285715 | 1
90.35714285714286 | 1
91.07142857142858 | 1
91.78571428571429 | 1
92.5 | 1
93.21428571428572 | 1
93.92857142857143 | 1
94.64285714285715 | 1
95.35714285714286 | 1
96.07142857142858 | 1
96.78571428571429 | 1
97.5 | 1
98.21428571428572 | 1
98.92857142857143 | 1
99.64285714285715 | 1