Loading
Status: Live
Statistics Project- for Excel User!! please follow directions on attachment
Date Posted: 08/10/2019
Category: Mathematics
Due Date: 22/10/2019
Willing to Pay: $40.00
Instruction
MAT 109 DATA PROJECT OBJECTIVE: The purpose of this project is to describe a data set of your choice using the descriptive tools learned in this course. You will also estimate the population mean, test a claim about the population mean, and create an infographic. Excel will be used for the data analysis portion of the project. FORMAT: The 5 data analysis sections of the project are to be submitted in a single EXCEL spreadsheet (workbook, saved as Excel 2016) with 5 separate tabs, one for each section and labeled appropriately. The infographic will be a single 8.5 x 11 page, either a WORD document or PowerPoint slide. DATA SELECTION:Select a data set to use for your project. It could be a data set from work, personal data (bills, budget, glucose readings, etc), or magazine/internet/newspaper data. The following website https://www.bls.gov/Data/ is a great source for data. This is the federal government’s source, Bureau of Labor Statistics. This will be an observational study, as you will be using data that is already available. Data must be numeric. You want to include at least 100 data values. In your description, include how many rows? How many columns? Operationally define your variables; what are the labels for the rows and columns?TWO GRAPHS:Create 2 graphs for your data set. One must be a histogram. The other can be a time series, boxplot, scatterplot etc. From the histogram, describe the shape of the distribution of data, center, and variation. Does this data set appear to have outliers? Are there any trends present? Explain with several complete sentences (short essay). DESCRIPTIVE STATISTICS: Run descriptive statistics for your data set. Do your numerical results support the description you provided in section 2 for your graphs? Explain using several complete sentences. Confirm any outliers by calculating, (mean + 3s) and (mean - 3s). Do any of your data values fall outside of that interval? Show the computation and discuss this in your short essay.ESTIMATION:Find a 95% confidence interval estimate for the population mean. State this and interpret your results (several complete sentences). HYPOTHESIS TEST:Select a claim about the population mean to statistically test for your data set. Use a 0.05 significance level. Make sure to include the null hypothesis (H0), alternative hypothesis (Ha), test statistic, critical value and p-value, decision (reject H0/do not reject H0), and interpretation.INFOGRAPHIC or DASHBOARD DESIGN:What is an infographic? In our modern technology-driven world, software programs and websites (even apps) have dashboards showing us our usage statistics or important information about our business operations. Fall 2019For this project, you are to create an 8.5 x 11 infographic for your data set. Make sure to include some of the information from your data analysis. Click here for some examples: https://blog.hubspot.com/marketing/best-infographics-2016#.W6bHSDhMhyM.mailto
Homework Been Upload
No File uploaded yet.
Bidders
29
Average bid
$57.41
Rated 9.54 earned 29122.66 around 970 assignments.
$55.00
Rated 9.2 earned 5251.48 around 161 assignments.
$40.00
Rated 9.2 earned 5308.21 around 172 assignments.
$50.00
Rated 9.44 earned 9587.52 around 280 assignments.
$40.00
Rated 8.72 earned 13681.91 around 419 assignments.
$100.00
Rated 9.21 earned 31364.26 around 907 assignments.
$40.00
Rated 9.37 earned 3049.42 around 102 assignments.
$40.00
Rated 8.79 earned 2788.42 around 96 assignments.
$40.00
Rated 9.89 earned 14174.39 around 274 assignments.
$40.00
Rated 9.19 earned 2422.45 around 68 assignments.
$40.00
Rated 8.96 earned 6069.84 around 191 assignments.
$40.00
Rated 9.66 earned 6446.42 around 189 assignments.
$150.00
Rated 8.36 earned 1012.00 around 40 assignments.
$50.00
Rated 9.51 earned 13212.81 around 493 assignments.
$40.00
Rated 9.05 earned 15702.68 around 411 assignments.
$40.00
Rated 9.44 earned 36150.02 around 1259 assignments.
$50.00
Rated 9.51 earned 8269.26 around 334 assignments.
$130.00
Rated 8.66 earned 11620.00 around 363 assignments.
$40.00
Rated 9.68 earned 3513.13 around 117 assignments.
$40.00
Rated 9.42 earned 4653.03 around 173 assignments.
$40.00
Rated 9.46 earned 12615.19 around 409 assignments.
$140.00
Rated 8.5 earned 570.00 around 29 assignments.
$40.00
Rated 9.31 earned 23574.00 around 913 assignments.
$40.00
Rated 9.38 earned 400.07 around 16 assignments.
$40.00
Rated 9.39 earned 9029.75 around 302 assignments.
$100.00
Rated 9.17 earned 103490.19 around 3191 assignments.
$40.00
Rated 9.16 earned 43319.45 around 1425 assignments.
$40.00
Rated 9.52 earned 7920.90 around 311 assignments.
$50.00
earned 100.00 around 1 assignments.
$70.00