Exploratory Data Analysis (EDA) with Google Spreadsheet Objectives: Learn different tools to explore data sets both quan

Business, Finance, Economics, Accounting, Operations Management, Computer Science, Electrical Engineering, Mechanical Engineering, Civil Engineering, Chemical Engineering, Algebra, Precalculus, Statistics and Probabilty, Advanced Math, Physics, Chemistry, Biology, Nursing, Psychology, Certifications, Tests, Prep, and more.
Post Reply
answerhappygod
Site Admin
Posts: 899604
Joined: Mon Aug 02, 2021 8:13 am

Exploratory Data Analysis (EDA) with Google Spreadsheet Objectives: Learn different tools to explore data sets both quan

Post by answerhappygod »

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 Eda With Google Spreadsheet Objectives Learn Different Tools To Explore Data Sets Both Quan 1
Exploratory Data Analysis Eda With Google Spreadsheet Objectives Learn Different Tools To Explore Data Sets Both Quan 1 (71.27 KiB) Viewed 30 times
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
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!
Post Reply