Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Getting Started Go to Datasets and legends tab in Module 0 . Choose one of the datasets that interests you by exploring the source link
Getting Started
Go to Datasets and legends tab in Module
Choose one of the datasets that interests you by exploring the source link and legend.
From the dataset and legend identify which variables are categorical and which are quantitative,
then select one of each to use for this analysis.
o If you would prefer, you can find your own dataset, however, you must provide the link to
the source and use excel for the analysis.
Download the excel file.
Watch the Software Tutorial
Under Software and Simulations Week watch the tutorial on how to use Excel to:
o Create a barchart
o Construct a Pivot table of counts andor percents and provide it in your post.
o Create a histogram or boxplot.
o Calculate the mean and standard deviation and the fivenumber summary
Create your graphs and summaries based on your data and variables.
Create a barchart
o Plot must include a descriptive title and clean axis labels.
Construct a Pivot table of counts andor percents and provide it in your post.
Create a histogram or boxplot.
o Plot must include a descriptive title and clean axis labels.
Calculate the mean and standard deviation and the fivenumber summary provide them in a table
and paste them in your post.
Warning Have some fun with color but avoid the D options.
Answer the questions and make a post of your results.
Take a screenshot of each graphtable Save as an image so that you can upload them to your
discussion post. See tutorial on how to upload an image to the discussion board.
Add your images to the discussion board and answer the following questions in your post. See
example in Canvas.
Option to make a video post instead showing your work and your
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started