Analyzing and visualizing data

1. Good visualizations can help people make sense of data sets that are too large to interpret by looking at the raw data. In this part you will learn to use a spreadsheet tool to make visualizations of your own.
   There are many different kinds of charts that are used to visualize data. In this lesson, you will learn to make scatter, line, and bar charts, but there are many other types of visualizations that people use to interpret data in different ways. Look through the Data Visualization 101 Guide and familiarize yourself with the different chart types, paying particular attention to the scatter, line, and bar charts.
   Disclaimer: This exercise is about using charts to explore trends in the data – not about creating the world’s greatest chart. While the early parts of the lesson will walk you through very specific steps to make a particular chart, by the end of the exercise you will be creating your own customized charts to see what trends you can discover in the data.
   Follow this tutorial to create:
   Save Time On Research and Writing

   Hire a Pro to Write You a 100% Plagiarism-Free Paper.

   Get My Paper

   A scatter chart
   A line chart
   A bar chart
   In your answer document, respond to these questions about things you do in the tutorial:

   Share your Google sheet with the email address provided by your instuctor. Paste the URL in here.
   Place in your document a scatter chart similar to the one that you created in the Do A Visual Check of Scatter Chart part of the tutorial. It should have an appropriate title that includes your full name, an appropiate legand, and appropriate ranges.
   For this scatter chart: 

   What does this scatter chart help you notice about the data?
   Which age groups had the highest average ratings?
   Which age groups had the lowest?
   What other connections and trends can you see?

   Place in your document a line chart similar to the one that you created in the Do A Visual Check of Line Chartpart of the tutorial. It should have an appropriate title that includes your full name, an appropiate legand, and appropriate ranges.
   For this line chart: 

   Save Time On Research and Writing

   Hire a Pro to Write You a 100% Plagiarism-Free Paper.

   Get My Paper

   What does this line chart help you notice about the data?
   For which ages were the average ratings similar between men and women?
   For which ages were they different?
   What other connections and trends can you see from this chart?

   Place in your document a bar chart similar to the one that you created in the Do A Visual Check of Bar Chartpart of the tutorial. It should have an appropriate title that includes your full name, an appropiate legand, and appropriate ranges.
   For this bar chart: 

   What does this chart help you notice about the data?
   For which ages were the number of ratings similar between men and women?
   For which ages were they different?
   What other connections and trends can you see from this chart?

2. Link:   http://students.cs.uri.edu/~forensics/courses/CSC101/assignments/data_tutorials/tutorial1.html

.7

7

7

35

9

22

2.85 20

5

5

2.64 84

5

3

16

6

4

17

4

1

5

3.65

5

19

7

7

9

20

3.4

1

9

22

7

1

23 3.3

0

5

3.5

0

25

26

8

3.65

27

3.4

3.56

28 3.7

3.68

3.71

30 3.49

3.6

3.42

31

3.51

32 3.61

3.61

3.64

3.7

34 3.44

26

35 3.77

36

37 3.72

3.93

3.69

38 3.47

394

39 3.63

3.63

40 3.59

3.59

3.59

41 3.6

3.61

42 3.47

3.54

43 3.7

3.77

3.66

44 3.57

3.52

3.61 745

45 3.78

3.71

46 3.65

47

3.71 63 3.44

48 3.59

3.45

3.63

49 3.65

3.52

3.73 685

50 3.48

3.62

51 3.73

3.7

52 3.68

3.7 70 3.68

53

3.81

54 3.4

3.4 60 3.4 89

55 3.64

3.5 26 3.64

56 3.54

3.51

57 3.61

3.7 54 3.6

58

83 4.12 83

59

41

38

3

60 3.67

3.67 1211

61 3.95 96 3.95 96
62 3.49 37

17 3.6 20

63 3.51 35 3.51 35
64 3.47 66 3.47 66
65 3.63

3.63 177

66 3.19 32 3.19 32
68 3.5 66 3.5 66
69 3.72

3.72 109

70 3.7 37 3.4 10 3.81 27
73 3.9 41 3.9 41

3.53

3.54

3.53

																											age	avg rating	number of ratings	avg rating women	number of women	avg rating men	number of men
7									3					35			3.7
	10						3.5			22				3.	59
11		2.85				20
13							3.4	1			37	2.98		40								3.6	97
14		2.	64		84
15	3.	23			27		3.	42		16	2.95	112
3.	28		25						3.	61		62	3.		17		19
			3.64	5	30			3.	44		36		3.	65		49
18		3.78	13	50			3.9						66			68
	3.3	2	57	3.			26		47	3.	39	2098
			3.71	2797	3.84	804		3.66	1993
21			3.49	1910		52			3.52	1		38
		3.19	2		60	2.	51		89	3.	55	1716
1825	3.14		34	3.34	1	48
24	3061				3.72		56	3.	46	2501
	3.56	2	394				3.68	3		63			3.		54	20	31
3.16	2	53	398	3.07	2140
				3.51	3605	1135	24		70
1998	624	1374
29					3.47	2536		3.54	7		96	3.44	1740
23			32	928	1404
3.				41	1921	3.15	519	1402
2302			3.53	218	2084
33	2237	520						3.63	1717
775		3.	69	3.	43	749
2336		3.93	1216	3.	58	1120
3.	45	1549			3.81	472	3.29	1077
	745	116	629
1307			3.95	3.26	913
1585		3.62	362	1223
1254	335	919
658		3.57	118	540
1144	3.11	198	946
1055	343	712
1251	506
616	3.97	155	461
641		3.48	200			3.	73	441
	3.45	1123	1060
1229	300	929
1046	361
1304	3.33	640	664
1550	3.96	197	1353
503	433
3.		83	598	3.89	167	431
149
499	473
424	126	3.55	298
814	760
	4.12
3.85	3.87			3.67
	1211
3.35
	177
	109
Grand Total	65535	16716	48819