For the upcoming Fall semester, freshmen are hunting for dorms

profiletutor4helpyou
data.xlsx

Sheet1

Apartment Prices W/out a Gym (X₁) Apt Prices W/ a Gym (X₂) Apt Prices 5 Minutes (X₁) Apt Prices 10 Minutes (X₂)
760.00 800.00 800.00 900.00
940.00 770.00 770.00 1,140.00
1,090.00 900.00 900.00 780.00
1,100.00 930.00 930.00 990.00
950.00 820.00 820.00 850.00
920.00 960.00 960.00 790.00
810.00 1,000.00 1,000.00 1,030.00
900.00 1,100.00 1,100.00 1,090.00
1,140.00 1,050.00 1,050.00 770.00
780.00 1,020.00 1,020.00 1,060.00
990.00 970.00 970.00 1,150.00
850.00 880.00 880.00 1,080.00
790.00 830.00 830.00 820.00
1,030.00 1,030.00 1,030.00 880.00
1,090.00 1,120.00 1,120.00 1,000.00
770.00 1,170.00 1,170.00 1,040.00
1,060.00 910.00 910.00 850.00
1,150.00 770.00 770.00 1,130.00
1,080.00 840.00 840.00 1,010.00
820.00 990.00 990.00 780.00
880.00 1,120.00 1,120.00 770.00

Sheet2

Stress Test Score Before (X₁) Stress Test Score After (X₂)
10.00 9.00
15.00 5.00
12.00 7.00
20.00 14.00
10.00 11.00
17.00 5.00
12.00 9.00
14.00 10.00
18.00 8.00
13.00 10.00
14.00 9.00
19.00 7.50
14.00 11.00
21.00 9.00
11.00 8.00

Sheet3

Pool_morning Pool_evening Hottub_morning Hottub_evening
1 0 0 0
1 0 0 0
0 1 0 0
0 0 0 1
0 0 1 0
0 1 0 0
0 1 0 0
0 0 0 1
0 0 1 0
0 0 1 0
0 1 0 0
0 0 0 1
1 0 0 0
0 0 1 0
0 1 0 0
0 0 0 1
0 0 0 1
1 0 0 0
0 1 0 0
0 0 0 1

Sheet4

Candy Frequency Price Convenient
1 5 $1.00 Yes
5 1 $1.50 No
3 1 $0.75 No
3 7 $1.50 Yes
2 4 $1.00 Yes
1 9 $1.00 Yes
1 5 $1.50 Yes
1 6 $1.25 Yes
5 0 $0.50 No
5 3 $1.50 No
5 8 $1.25 Yes
4 2 $1.75 No
5 4 $1.25 Yes
1 5 $1.00 Yes
2 6 $1.00 Yes
3 4 $1.25 No
4 1 $0.50 No
1 2 $0.75 No
1 8 $1.00 Yes
5 7 $1.25 Yes