Answer Happy

Exploratory Data Analysis (EDA) with Google
Spreadsheet
Objectives:
Learn different tools to explore data sets both
quantitative and qualitative and to summarize their main
characteristics with visual methods.
Learn some basic functions in Google
Spreadsheet
Tasks:
Quantitative Data
There are two samples provided. Your goal is to explore
these two quantitative data sets by providing the following
features:
Gain maximum insight into the data set and its
underlying structure
Provide mean, variance, standard deviance for and 5
number summary
Identify outliers
Provide at least 2 appropriate visual methods
(histograms, box plots, stem-leaf graph, dot plots, etc). Remember
to include the main title for each graph, and axis
title.
Identify the shape of the distribution (skewed left,
skewed right, bell-shaped, uniform, etc)
Construct Confidence Interval using t and z
distributions (Optional)
Find the margin of Error with 95% confidence using t and
z distribution
Construct Confidence Interval with 95% confidence using
t and z distribution
Exploratory Data Analysis 1 Quantitative Data Set A Exploring the Duta Bet Important Statistics summary number Led Quare Min 1st Quarte Median Sample Sample Other important Statis Varange Standard Devian Mean Sample Sample 2 Identify Out Lower bound Upper bound OR outen Data Number of mes UWT sudarts travel to school per day Sample 1 Sample 2 50 7 48 77 30 24 119 17 BC 87 44 30 4 69 79 B 55 11 50 79 5 517 78 120 1 87 48 12 41 1 47 100 106 19 18 76 9 51 54 29 31 15 46 60 59 91 40 63 110 37 103 39 Sample 1 Sample 2 PH Note: You will provide a frequency histogram for each sample here a 志强者!? 75 84 60 4 50 4e 5 74 42 46 54 42 73 64 None you will provide a box plot borcach ample here 117 92 31 71 69 26 66 92 55 30 63 112 92 100 46 90 6 47 104 83 91 110 87 Provide the shape of each sample's distribution including your justification here Margin of Emor w 95confidence Confidence intervals Otona Confidence interval with confidence distribution distribution lower bound upper bound lower bound per bound dison dibution