Excel/Statistics Homework

quant_module_3_spreadsheet.xlsx

Home >Mathematics homework help >Numerical analysis homework help >Excel/Statistics Homework

Self Esteem

y	X2	X3	X1	X4	X5	X6	X7	Categorical Variables				Part	a	b
Self Esteem	YrsEdu	Age	MonWork	MS2	MS3	MS4	SL	SL	MS	Question 1		Grader
2	9	52	4	0	0	0	0	None	Single
2	9	52	4	0	0	0	0	None	Single
3	11	40	14	0	0	0	1	Direct	Single
3	9	46	10	0	0	0	1	Direct	Single
3	12	40	12	0	0	0	0	None	Single
3	10	47	6	0	0	0	0	None	Single
3	10	50	4	0	0	0	0	None	Single
3	10	44	5	0	0	0	0	None	Single
3	9	46	9	1	0	0	1	Direct	Married
3	9	47	4	1	0	0	0	None	Married
3	10	51	4	1	0	0	0	None	Married
3	9	47	11	0	1	0	1	Direct	Separated
3	9	51	10	0	1	0	1	Direct	Separated	Part	Grader
3	10	42	12	0	1	0	1	Direct	Separated	c
3	9	48	9	0	1	0	1	Direct	Separated	d
3	9	46	3	0	1	0	0	None	Separated
3	12	37	14	0	1	0	0	None	Separated
3	12	35	13	0	1	0	0	None	Separated
3	9	43	3	0	1	0	0	None	Separated
3	10	45	4	0	1	0	0	None	Separated
3	10	50	10	0	0	1	1	Direct	Divorced
3	9	46	8	0	0	1	0	None	Divorced
3	11	49	2	0	0	1	0	None	Divorced
3	12	48	7	0	0	1	0	None	Divorced
3	10	45	8	0	0	1	0	None	Divorced
3	9	47	9	0	0	1	0	None	Divorced
3	9	46	6	0	0	1	0	None	Divorced
3	9	47	4	0	0	1	0	None	Divorced
3	10	45	3	0	0	1	0	None	Divorced
3	10	47	2	0	0	1	0	None	Divorced
4	13	28	12	0	0	0	1	Direct	Single
4	12	42	37	0	0	0	1	Direct	Single
4	10	40	23	0	0	0	1	Direct	Single
4	12	38	23	0	0	0	1	Direct	Single
4	9	45	10	0	0	0	1	Direct	Single
4	10	47	10	0	0	0	1	Direct	Single
4	9	47	9	0	0	0	1	Direct	Single
4	12	39	23	1	0	0	0	None	Married
4	10	43	12	0	1	0	1	Direct	Separated
4	11	39	21	0	1	0	0	None	Separated
4	12	33	10	0	1	0	0	None	Separated
4	12	35	11	0	1	0	0	None	Separated
4	12	45	14	0	0	1	0	None	Divorced
4	13	41	12	0	0	1	0	None	Divorced
4	9	43	5	0	0	1	0	None	Divorced
5	12	28	51	0	0	0	1	Direct	Single	Part	Grader
5	14	32	40	0	0	0	1	Direct	Single	e
5	14	38	29	0	0	0	1	Direct	Single
5	14	36	29	0	0	0	1	Direct	Single
5	14	39	29	0	0	0	1	Direct	Single
5	13	39	21	0	0	0	1	Direct	Single
5	9	48	7	1	0	0	1	Direct	Married
5	12	29	24	1	0	0	1	Direct	Married
5	13	26	32	1	0	0	1	Direct	Married
5	14	30	37	0	1	0	1	Direct	Separated
5	13	26	31	0	0	1	1	Direct	Divorced
6	12	27	58	0	0	0	1	Direct	Single
6	12	38	17	0	0	0	0	None	Single
6	16	28	61	1	0	0	1	Direct	Married
6	14	38	64	0	1	0	1	Direct	Separated
										Part	Grader
										f

Bank

y variable					Question 2:
Salary: current annual salary in thousands of dollars.					Part	Grader
					a
x variables					b
YrsExp: years experience with this Bbank					c
YrsPrior: number of years prior work experience at another bank.
Gender: (categorical), 1 = Female, 0 = Male
Bank salary data
Employee	Salary	YrsExp	YrsPrior	Gender
1	32	6	1	Male
2	39.1	17	1	Female
3	33.2	15	0	Female
4	30.6	11	7	Female
5	29	6	0	Male
6	30.5	6	0	Female
7	30	7	0	Female
8	27	11	2	Male
9	34	7	0	Female
10	29.5	12	0	Female
11	26.8	12	2	Female
12	31.3	11	8	Female
13	31.2	12	0	Female
14	34.7	13	6	Female
15	30	7	0	Female
16	31	6	0	Female
17	27	9	0	Female
18	29.6	11	9	Female
19	32.6	8	6	Female
20	29.6	7	3	Female	Part	Grader
21	29.5	7	2	Female	d
22	31	6	3	Male
23	28.5	8	0	Female
24	26.7	6	4	Male
25	30.75	6	1	Male
26	29.5	6	1	Male
27	42.2	19	6	Female
28	37.6	16	0	Female
29	34	15	6	Female
30	33	7	7	Female
31	28.76	10	4	Female
32	35.4	14	0	Female
33	31	6	8	Male
34	38.8	21	2	Female
35	34.3	17	0	Female
36	35	22	0	Female
37	34.6	6	2	Female
38	28.5	5	4	Female
39	29.5	14	0	Female
40	30.5	6	2	Male
41	34.2	8	1	Female
42	43.6	18	0	Female
43	33.5	10	0	Female
44	33	15	1	Female
45	45.3	21	0	Female
46	38.8	20	3	Male
47	29.9	13	0	Female
48	31.2	8	10	Male
49	34	18	0	Female
50	30.45	5	0	Female
51	35.5	6	3	Male
52	34	7	10	Female
53	29.1	10	0	Female
54	29.65	11	0	Female
55	29.2	18	1	Female
56	29.8	12	0	Female
57	33.5	19	0	Female
58	34	11	0	Female
59	29.6	12	0	Female
60	34	21	0	Female
61	37.25	6	8	Female
62	33	9	3	Male
63	28.6	7	0	Female
64	36	8	1	Female
65	37.3	7	4	Female
66	29.9	10	4	Male
67	31.5	14	8	Female
68	41.4	8	4	Female
69	32.74	20	5	Female
70	33.5	6	1	Male
71	32	8	9	Female
72	30.8	12	0	Female
73	42	6	3	Female
74	34	7	0	Male
75	32.5	19	0	Female
76	31.7	12	10	Female
77	36.5	6	0	Male
78	33	7	0	Male
79	31.2	11	0	Female
80	34	11	0	Female
81	33	9	0	Female
82	33.9	7	4	Female
83	39	6	9	Female
84	34.92	15	18	Male
85	39	6	5	Male
86	34	11	0	Female
87	31.9	9	7	Female
88	37	6	1	Male
89	34	7	0	Male
90	36.4	6	2	Female
91	38.2	18	1	Female
92	35.3	18	0	Female
93	34.5	6	2	Male
94	30.5	15	0	Female
95	30	5	2	Male
96	37.3	11	0	Female
97	40.2	8	0	Female
98	35.5	8	0	Male
99	35	14	0	Female
100	38	7	3	Female
101	35.3	12	0	Female
102	34.1	17	0	Female
103	43.2	7	5	Female
104	36.1	18	5	Female
105	34.6	10	3	Female
106	36	8	0	Male
107	36.2	10	2	Female
108	37.5	10	0	Female
109	41	7	12	Female
110	35.6	13	0	Female
111	39.8	8	5	Female
112	41.3	14	4	Female
113	42.5	12	7	Female
114	45.8	7	8	Female
115	34.9	8	6	Female
116	41.5	7	0	Male
117	38	8	0	Female
118	35	9	0	Female
119	40	9	0	Female
120	36	8	0	Male
121	33.7	12	0	Female
122	36.3	8	4	Male
123	38	6	2	Female
124	39.5	7	0	Female
125	36.3	10	5	Female
126	32.5	11	2	Female
127	37	15	6	Female
128	32.6	6	1	Female
129	36	7	0	Female
130	35	6	0	Female
131	43.6	6	5	Female
132	33.8	11	0	Female
133	35.3	24	0	Female
134	42.4	19	6	Female
135	39.5	8	0	Male
136	43.5	28	10	Female
137	42	9	1	Male
138	40.3	24	9	Female
139	44	9	5	Male
140	40.66	28	2	Female
141	39.7	16	1	Female
142	45	9	5	Female
143	43.9	10	0	Female
144	38	11	3	Female
145	39.02	8	3	Female
146	44.5	8	3	Male
147	41	7	1	Male
148	44	9	3	Male
149	44	9	0	Male
150	42.5	8	4	Female
151	40.26	10	3	Female
152	44.5	8	1	Male
153	35.5	16	9	Female
154	42.5	9	0	Male
155	44	10	0	Female
156	45	9	2	Male
157	44.4	18	4	Female
158	38	20	0	Female
159	41.8	7	0	Male
160	45.5	26	0	Male
161	42.5	8	4	Male
162	44	6	12	Female
163	54.3	22	8	Female
164	44.8	29	0	Female
165	47	9	4	Male
166	43.8	18	0	Female
167	48	15	4	Female
168	42.7	12	0	Female
169	48.5	17	1	Female
170	42	19	0	Female
171	45.5	19	1	Female
172	44.5	14	0	Female
173	51.2	16	2	Female
174	47.5	10	0	Male
175	44.5	11	0	Female
176	47	11	0	Male
177	47	9	10	Male
178	43.1	20	4	Female
179	49	11	2	Male
180	48.5	11	0	Male
181	45	11	5	Female
182	52.5	19	5	Female
183	47.5	9	2	Male
184	48	10	0	Male
185	46.5	11	4	Male
186	61.5	15	2	Female
187	50	12	2	Female
188	61.8	15	2	Female
189	43	19	0	Female
190	47	14	1	Male
191	58.5	12	6	Female
192	55	19	7	Male
193	57	27	3	Male
194	57	20	1	Male
195	60	17	0	Male
196	60	16	0	Male
197	59	22	4	Male
198	60	15	0	Male
199	65	23	0	Male
200	52	23	1	Male
201	58	25	0	Male
202	60	24	0	Male
203	74	42	0	Male
204	95	37	0	Male
205	97	39	0	Male
206	88	35	0	Male
207	94	38	0	Male
208	30	36	0	Female

Builder

Measurements taken on 63 single-family residences						Question 3:
						Part
	sales price (x $1,000)	square feet	rooms	bedrooms	age	a
Residence	Y	X1	X2	X3	X4
1	53.5	1008	5	2	35
2	49.0	1290	6	3	36
3	50.5	860	8	2	36
4	49.9	912	5	3	41
5	52.0	1204	6	3	40
6	55.0	1204	5	3	10
7	80.5	1764	8	4	64
8	86.0	1600	7	3	19
9	69.0	1255	5	3	16
10	149.0	3600	10	5	17
11	46.0	864	5	3	37
12	38.0	720	4	2	41
13	49.5	1008	6	3	35
14	105.0	1950	8	3	52
15	152.5	2086	7	3	12
16	85.0	2011	9	4	76
17	60.0	1465	6	3	102
18	58.5	1232	5	2	69
19	101.0	1736	7	3	67
20	79.4	1296	6	3	11
21	125.0	1996	7	3	9
22	87.9	1874	5	2	14
23	80.0	1580	5	3	11
24	94.0	1920	5	3	14	Part
25	74.0	1430	9	3	16	b
26	69.0	1486	6	3	27
27	63.0	1008	5	2	35
28	67.5	1282	5	3	20
29	35.0	1134	5	2	74
30	142.5	2400	9	4	15
31	92.2	1701	5	3	15
32	56.0	1020	6	3	16
33	63.0	1053	5	2	24
34	60.0	1728	6	3	26
35	34.0	416	3	1	42
36	52.0	1040	5	2	9
37	75.0	1496	6	3	30
38	93.0	1936	8	4	39
39	60.0	1904	7	4	32
40	73.0	1080	5	2	24
41	71.0	1768	8	4	74
42	83.0	1503	6	3	14
43	90.0	1736	7	3	16
44	83.0	1695	6	3	12
45	115.0	2186	8	4	12
46	50.0	888	5	2	34
47	55.2	1120	6	3	29
48	61.0	1400	5	3	33
49	147.0	2165	7	3	2
50	210.0	2353	8	4	15
51	60.0	1536	6	3	36
52	100.0	1972	8	3	37
53	44.5	1120	5	3	27
54	55.0	1664	7	3	79
55	53.4	925	5	3	20
56	65.0	1288	5	3	2
57	73.0	1400	5	3	2
58	40.0	1376	6	3	103
59	141.0	2038	12	4	62
60	68.0	1572	6	3	29
61	139.0	1545	6	3	9
62	140.0	1993	6	3	4
63	55.0	1130	5	2	21

Sales

Sales	Time	Poten	AdvExp	Share	Change	Accounts	Work	Rating	Question 4:
3669.88	43.1	74065.1	4582.9	2.51	0.34	74.86	15.05	4.9	Part
3473.95	108.13	58117.3	5539.8	5.51	0.15	107.32	19.97	5.1	a
2295.1	13.82	21118.5	2950.4	10.91	-0.72	96.75	17.34	2.9
4675.56	186.18	68521.3	2243.1	8.27	0.17	195.12	13.4	3.4
6125.96	161.79	57805.1	7747.1	9.15	0.5	180.44	17.64	4.6
2134.94	8.94	37806.9	402.4	5.51	0.15	104.88	16.22	4.5
5031.66	365.04	50935.3	3140.6	8.54	0.55	256.1	18.8	4.6
3367.45	220.32	35602.1	2086.2	7.07	-0.49	126.83	19.86	2.3
6519.45	127.64	46176.8	8846.2	12.54	1.24	203.25	17.42	4.9
4876.37	105.69	42053.2	5673.1	8.85	0.31	119.51	21.41	2.8
2468.27	57.72	36829.7	2761.8	5.38	0.37	116.26	16.32	3.1
2533.31	23.58	33612.7	1991.8	5.43	-0.65	142.28	14.51	4.2	Part
2408.11	13.82	21412.8	1971.5	8.48	0.64	89.43	19.35	4.3	b
2337.38	13.82	20416.9	1737.4	7.8	1.01	84.55	20.02	4.2
4586.95	86.99	36272	10694.2	10.34	0.11	119.51	15.26	5.5
2729.24	165.85	23093.3	8618.6	5.15	0.04	80.49	15.87	3.6
3289.4	116.26	26878.6	7747.9	6.64	0.68	136.58	7.81	3.4
2800.78	42.28	39572	4565.8	5.45	0.66	78.86	16	4.2
3264.2	52.84	51866.1	6022.7	6.31	-0.1	136.58	17.44	3.6
3453.62	165.04	58749.8	3721.1	6.35	-0.03	138.21	17.98	3.1
1741.45	10.57	23990.8	861	7.37	-1.63	75.61	20.99	1.6
2035.75	13.82	25694.9	3571.5	8.39	-0.43	102.44	21.66	3.4
1578	8.13	23736.3	2845.5	5.15	0.04	76.42	21.46	2.7	Part
4167.44	58.44	34314.3	5060.1	12.88	0.22	136.58	24.78	2.8	c
2799.97	21.14	22809.5	3552	9.14	-0.74	88.62	24.96	3.9
									Part
									d

Car

Car	Size	Price ($)	Cost/Mile	Road-Test Score	Predicted Reliability	Value Score	Part
Toyota Corolla (base, manual)	Small Sedan	16,419	0.44	70	4	1.99	a
Mazda3 i Touring (manual)	Small Sedan	18,895	0.50	74	5	1.94
Toyota Corolla LE	Small Sedan	18,404	0.47	71	4	1.89
Mazda3 i Touring	Small Sedan	19,745	0.52	70	5	1.82
Hyundai Elantra GLS	Small Sedan	18,445	0.53	80	3	1.64
Nissan Sentra 2.0 SL	Small Sedan	20,150	0.57	74	4	1.51
Kia Forte Sedan EX	Small Sedan	19,040	0.57	71	3	1.32
Ford Focus SE	Small Sedan	20,280	0.52	68	2	1.30
Ford Fiesta SE	Small Sedan	16,595	0.47	61	2	1.25
Volkswagen Jetta SE (2.5)	Small Sedan	20,300	0.54	60	3	1.24
Volkswagen Jetta TDI	Small Sedan	25,100	0.50	68	2	1.18
Chevrolet Cruze LS (1.8)	Small Sedan	18,375	0.57	67	1	0.96
Chevrolet Cruze 1LT (1.4T)	Small Sedan	20,530	0.60	69	1	0.91
Nissan Altima 2.5 S (4-cyl.)	Family Sedan	23,970	0.59	91	4	1.75
Kia Optima LX (2.4)	Family Sedan	21,885	0.58	81	4	1.73
Subaru Legacy 2.5i Premium	Family Sedan	23,830	0.59	83	4	1.73
Ford Fusion Hybrid	Family Sedan	32,360	0.63	84	5	1.70
Honda Accord LX-P (4-cyl.)	Family Sedan	23,730	0.56	80	4	1.62
Mazda6 i Sport (4-cyl.)	Family Sedan	22,035	0.58	73	4	1.60
Hyundai Sonata GLS (2.4)	Family Sedan	21,800	0.56	89	3	1.58
Ford Fusion SE (4-cyl.)	Family Sedan	23,625	0.57	76	4	1.55
Chevrolet Malibu LT (4-cyl.)	Family Sedan	24,115	0.57	74	3	1.48
Kia Optima SX (2.0T)	Family Sedan	29,050	0.72	84	4	1.43	Part
Ford Fusion SEL (V6)	Family Sedan	28,400	0.67	80	4	1.42	b
Nissan Altima 3.5 SR (V6)	Family Sedan	30,335	0.69	93	4	1.42
Hyundai Sonata Limited (2.0T)	Family Sedan	28,090	0.66	89	3	1.39
Honda Accord EX-L (V6)	Family Sedan	28,695	0.67	90	3	1.36
Mazda6 s Grand Touring (V6)	Family Sedan	30,790	0.74	81	4	1.34
Ford Fusion SEL (V6, AWD)	Family Sedan	30,055	0.71	75	4	1.32
Subaru Legacy 3.6R Limited	Family Sedan	30,094	0.71	88	3	1.29
Chevrolet Malibu LTZ (V6)	Family Sedan	28,045	0.67	83	3	1.20
Chrysler 200 Limited (V6)	Family Sedan	27,825	0.70	52	5	1.20
Chevrolet Impala LT (3.6)	Family Sedan	28,995	0.67	63	3	1.05
Lexus ES 350	Upscale Sedan	38,615	0.77	91	5	1.45
Acura TL (base)	Upscale Sedan	36,465	0.75	82	5	1.41
Lexus IS 250	Upscale Sedan	33,734	0.75	84	5	1.40
Infiniti G25 Journey	Upscale Sedan	34,225	0.73	86	4	1.37
Lexus HS 250h Premium	Upscale Sedan	38,939	0.75	83	4	1.36
Acura TSX (4-cyl.)	Upscale Sedan	29,675	0.67	84	3	1.35
Infiniti G37 Journey	Upscale Sedan	37,225	0.79	95	4	1.33
Toyota Avalon Limited	Upscale Sedan	35,485	0.73	86	3	1.27
Hyundai Genesis 3.8	Upscale Sedan	39,850	0.78	92	3	1.22
Volvo S60 T5	Upscale Sedan	35,100	0.76	77	4	1.18
Nissan Maxima 3.5 SV	Upscale Sedan	33,700	0.78	83	3	1.17
Buick Regal CXL (2.4)	Upscale Sedan	28,840	0.65	77	2	1.14
Lincoln MKZ	Upscale Sedan	37,160	0.80	77	4	1.12
BMW 328i	Upscale Sedan	39,175	0.79	77	3	1.10
Audi A4 Premium Quattro	Upscale Sedan	35,895	0.76	76	3	1.08	Part
Ford Taurus Limited	Upscale Sedan	34,980	0.78	73	3	1.07	c
Buick Regal CXL (turbo)	Upscale Sedan	32,135	0.71	79	2	1.06	Smallest
Mercedes-Benz C300 Sport	Upscale Sedan	37,325	0.83	77	3	1.04	Largest
Volkswagen CC Luxury (2.0T)	Upscale Sedan	32,680	0.73	82	2	1.04
Saab 9-3 2.0T	Upscale Sedan	31,615	0.70	69	3	1.00
Buick LaCrosse CXS (V6)	Upscale Sedan	37,555	0.81	74	2	0.82
							Part
							d
							Part
							e

_STDS_DG3209D225

Name

SelfEsteem

StatTools Version that generated sheet, Major

StatTools Version that generated sheet, Minor

StatTools Version that generated sheet, Revision

Min. StatTools Version to Read Sheet, Major (note ST versions before 1.1.1 don't perform forward compatibility check)

Min. StatTools Version to Read Sheet, Minor

Min. StatTools Version to Read Sheet, Revision

Min. StatTools version to not put up warning about extra info, Major

Min. StatTools version to not put up warning about extra info, Minor

Min. StatTools version to not put up warning about extra info, Revision

GUID

DG3209D225

Format Range

FALSE

Variable Layout

Columns

Variable Names In Cells

TRUE

Variable Names In 2nd Cells

TRUE

Data Set Ranges

Data Sheet Format

Formula Eval Cell

Num Stored Vars

1 : Info

VG20B96C85D379B1A

var1

ST_SelfEsteem

TRUE

1 : Ranges

1 : MultiRefs

2 : Info

VG332891741926E07B

var2

ST_YrsEdu

TRUE

2 : Ranges

2 : MultiRefs

3 : Info

VG3B832608181446DB

var3

ST_Age

TRUE

3 : Ranges

3 : MultiRefs

4 : Info

VG39D1A9D3158A8AF9

var4

ST_MonWork

TRUE

4 : Ranges

4 : MultiRefs

5 : Info

VG2421FE3E20F08BB0

var5

ST_MS2

TRUE

5 : Ranges

5 : MultiRefs

6 : Info

VG3328C7793842EA1F

var6

ST_MS3

TRUE

6 : Ranges

6 : MultiRefs

7 : Info

VG15DBFF0D3B6B08FF

var7

ST_MS4

TRUE

7 : Ranges

7 : MultiRefs

8 : Info

VG23A682D32D1E64BF

var8

ST_SL

TRUE

8 : Ranges

8 : MultiRefs

_STDS_DG4C7139F

Name

Bank

StatTools Version that generated sheet, Major

StatTools Version that generated sheet, Minor

StatTools Version that generated sheet, Revision

Min. StatTools Version to Read Sheet, Major (note ST versions before 1.1.1 don't perform forward compatibility check)

Min. StatTools Version to Read Sheet, Minor

Min. StatTools Version to Read Sheet, Revision

Min. StatTools version to not put up warning about extra info, Major

Min. StatTools version to not put up warning about extra info, Minor

Min. StatTools version to not put up warning about extra info, Revision

GUID

DG4C7139F

Format Range

FALSE

Variable Layout

Columns

Variable Names In Cells

TRUE

Variable Names In 2nd Cells

TRUE

Data Set Ranges

ERROR:#VALUE!

Data Sheet Format

Formula Eval Cell

Num Stored Vars

1 : Info

VG26ACC8711EB90D84

var1

ST_Employee

TRUE

1 : Ranges

1 : MultiRefs

2 : Info

VG25DAF4153000BFE1

var2

ST_Salary

TRUE

2 : Ranges

30.5

2 : MultiRefs

3 : Info

VG2668C55DFD18028

var3

ST_YrsExp

TRUE

3 : Ranges

3 : MultiRefs

4 : Info

VG195D7E6D2191048F

var4

ST_YrsPrior

TRUE

4 : Ranges

4 : MultiRefs

5 : Info

VGDEBD6B098D6E9C

var5

ST_Bank

TRUE

5 : Ranges

5 : MultiRefs

6 : Info

VG3B0C4C113FD9BC

var6

ST_Gender

TRUE

6 : Ranges

Female

6 : MultiRefs