Project

In your report please include a title page (Title Page:

 

provides the title of the study along with the names of the team members)

SECTION 1

In the first section of the project assignment please use this dataset: 

Housing_Price_Data.csv

Generally, one of the first things to do with new data is to get to know it by asking some general questions: Answer the questions below in one paragraph.

· What variables are included? What information can be obtained from this dataset?

· What type of variables are included: categorical (ordinal, nominal),  numerical (continuous, or discrete)?

· Is this sample or population data?

-After that, use proper techniques to visualize each variable and added them to your report.

For help see the videos: 

Pie (Links to an external site.)

Histogram (Links to an external site.)

https://mediaplayer.pearsoncmg.com/assets/Excel_DAT_busstats_BB_06,

 

Boxplot (Links to an external site.)

https://www.youtube.com/watch?v=TxuretcM5Uk&t=72s

Answer the questions below in one paragraph

· Please determine the variables with outliers ? And explain which central tendency you would use (which is proper: mean, median, and why?).

SECTION 2

In this section, use the following dataset 

Sample – Superstore.xls

 and analyze it with the tableau software (watch this video: 

tableau for beginner (Links to an external site.)

 ) https://www.youtube.com/watch?v=jEgVto5QME8&t=1166s

 

1. Introduction: is a section introducing the study with a one-paragraph scenario that mentions what the study is about and what the objectives are.

2. Data analysis: is a section, where you demonstrate your findings.

3. Summary of Findings: The report should end with a short paragraph that summarizes your findings and provides managerial insight for the company to take data-informed actions.

Only one member of each team needs to submit the team report to Canvas. Title your file using the following naming convention: “PROJECT LastName1, LastName2” (Example: Joe Jones and Adam Smith in Team C would have subject heading PROJECT Jones Smith Wang).

 

I will ask the following questions while grading your project assignemnts. 

Are analyses appropriate and well-presented?

Style: Are the language, tone and/or level of formality appropriate for the task and message?

Correct Use of Charts: Are the charts appropriate?

Correct use of descriptive statistics: mean, median, etc.

Are there problems with standard American usage (grammar, punctuation, and spelling)?

9

0

0

1

4000

7

0

65

1

126500

9

1 13

0 8

1365 1 19

34

1

1 14

1

00

0

1

1

0 10

0 15

1 15

136000

0 10

0 17

1 10

139900

0 13

1

0 20

1 15

1733 0 11

0 15

0 7

1 9

0 15

1 6

39

0 12

1 9

1 12

1 19

1 11

1 11

1 5

1 14

1 11

1 19

1 13

1 8

1 21

1 21

1 19

981 1 18

128000 1077 1 19

1 13

129000 1077 1 21

1 13

1 14

981 1 20

1 10

1 15

1 18

1 13

1559 1 12

150000

1 16

1 19

1 11

1 9

1 24

1 15

1 16

1 15

1 11

1 15

136000

1 15

139900

0 9

139900

1 14

145000 1733 1 9

1 10

1 12

151500

0 3

151500 1733 1 18

1 10

1 17

1 11

1 14

1 9

1 5

1 14

159000

1 14

2165 1 9

1 15

167000

1 21

1 13

0 19

170000

1 11

1 11

1 13

1 9

1 11

1 7

1 10

1 23

2053 1 13

181000

1 22

185000

1 21

1 8

1 9

2333 1 12

192000

1 8

1 14

192500

1 7

1 4

1 11

1 8

1 8

1 9

1 3

Price	Square Feet	Basement	Age
																																																																																											1		1										9																	0							1		3			7									1	4
					12			17	6							1		5
	126500					13						19
13						8
126900	1279
	128000
128500				18		22
	129000	1794
130950	1863			20
13							10	1363						15
132692	1441												11
132801	1	23
135207	2065
		136000	1833
1485
137500	1799
			139900	1461
			1733
141000	1401			16
142800	18					21
144900	2236
	145000
146000	2042
149280	1453
149900	1500
	150000	2019
152000	1521
15	24	1898
154646	1721
157293	1585
158100	2067
158149		2053
165000	1909
	170000	1892
171900	2219
173000		2165
184000	2281
193000	2444
255000	2878
119000			981
121500	885
123500			1077
126950
128694	907
130452	1189
135000	1311
136900
143000	1385
148000		1559
148879	1187
149347	1347
149700
1487
150800	1319
		151500	1950
155000	1424
158000	1587
159500	1675
	167000	2193
173750	2168
	185000	2301
	192000	1677
1389
1749
1503
147158	1448
147200	1703
1469
152500	1617
153500	2109
154000	1861
156700	1934
157400	1902
158500	1696
	159000	2267
1776
162400
164000	2073
1887
167900	2004
169000	2450
2046
170500	2386
572000	2141
172900	2177
173600	2129
674500	2133
174700	2217
175000	2239
	181000
2199
2118
188000	2104
190000		2333
191000
2431
	192500	2331
2422
204500	2367
210577	2351
213800	2611
215000	2449
216900	2574
252000	2873