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.39 earned 11122.81 around 408 assignments.
$50.00
Rated 9.55 earned 34871.70 around 1150 assignments.
$55.00
Rated 9.2 earned 5778.86 around 174 assignments.
$40.00
Rated 9.32 earned 7427.26 around 243 assignments.
$50.00
Rated 9.46 earned 11421.13 around 329 assignments.
$40.00
Rated 8.73 earned 14581.19 around 447 assignments.
$100.00
Rated 9.2 earned 32886.26 around 948 assignments.
$40.00
Rated 9.1 earned 3350.63 around 112 assignments.
$40.00
Rated 8.97 earned 3706.61 around 119 assignments.
$40.00
Rated 9.89 earned 17052.97 around 310 assignments.
$40.00
Rated 9.07 earned 3356.31 around 100 assignments.
$40.00
Rated 8.96 earned 6135.16 around 193 assignments.
$40.00
Rated 9.65 earned 6461.49 around 190 assignments.
$150.00
Rated 8.74 earned 1504.35 around 60 assignments.
$50.00
Rated 9.58 earned 16435.78 around 620 assignments.
$40.00
Rated 9.03 earned 16962.87 around 446 assignments.
$40.00
Rated 9.51 earned 9323.74 around 373 assignments.
$130.00
Rated 8.67 earned 11790.81 around 368 assignments.
$40.00
Rated 9.21 earned 6435.15 around 234 assignments.
$40.00
Rated 9.57 earned 7925.07 around 277 assignments.
$40.00
Rated 9.47 earned 14019.71 around 451 assignments.
$140.00
Rated 8.5 earned 610.19 around 31 assignments.
$40.00
Rated 9.25 earned 27551.78 around 1045 assignments.
$40.00
Rated 9.44 earned 1590.07 around 62 assignments.
$40.00
Rated 9.41 earned 9762.23 around 327 assignments.
$100.00
Rated 9.16 earned 106931.19 around 3300 assignments.
$40.00
Rated 9.18 earned 45663.45 around 1484 assignments.
$40.00
Rated 9.42 earned 42508.44 around 1462 assignments.
$50.00
earned 100.00 around 1 assignments.
$70.00