Loading...

Messages

Proposals

Stuck in your homework and missing deadline? Get urgent help in $10/Page with 24 hours deadline

Get Urgent Writing Help In Your Essays, Assignments, Homeworks, Dissertation, Thesis Or Coursework & Achieve A+ Grades.

Privacy Guaranteed - 100% Plagiarism Free Writing - Free Turnitin Report - Professional And Experienced Writers - 24/7 Online Support

Cpsinet org

20/12/2020 Client: saad24vbs Deadline: 7 Days

Create a Microsoft® Excel® spreadsheet with the two variables from your learning team's dataset.


Analyze the data with MegaStat®, StatCrunch®, Microsoft® Excel®or other statistical tool(s), including:


(a) Descriptive stats for each numeric variable


(b) Histogram for each numeric variable


(c) Bar chart for each attribute (non numeric) variable


(d) Scatter plot if the data contains two numeric variables


Determine the appropriate descriptive statistics.


(a) For normally distributed data use the mean and standard deviation.


(b) For significantly skewed data use the median and interquartile range.


Use the Individual Methodology Findings Template to complete the descriptive statistics. Use the Descriptive Statistics and Interpretation Example to develop an interpretation of the descriptive statistics.


Format your paper consistent with APA guidelines.


Submit both the spreadsheet and the completed Individual Methodology Findings Template.


Click the Assignment Files tab to submit your assignment.


TEMPLATE

Descriptive Statistics

Determine the appropriate descriptive statistics.


Note: If the data was normally distributed, use the mean and standard deviation. If the data was skewed significantly, use the median and interquartile range.


Numeric Variable Name1


Distribution: State if not normally distributed


Central Tendency:


Dispersion:


Number:


Min/Max:


Confidence Interval: (if distribution is normal)


Numeric Variable Name2 (if applicable)


Distribution: State if not normally distributed


Central Tendency:


Dispersion:


Number:


Min/Max:


Confidence Interval: (if distribution is normal)


Attribute Variable Name (if applicable)


Create a bar chart. Describe the proportions.


Descriptive Statistics Interpretation


Numeric Variable Name1


Describe the variable in laymen terms.


Numeric Variable Name2 (if applicable)


Describe the variable in laymen terms.


EXAMPLE


University of Phoenix Material


Descriptive Statistics and Interpretation Example


Interpretation Phrases


Central Tendency:


Mean = average of a set of data


Median = half or equal number of data is above and half or equal number of data is below. It is a midpoint in an ordered (sorted) set of data, a physical location


Mode = most frequent value in a set of data


Dispersion:


Standard deviation = variation


Interquartile range (IQR) = the middle 50% of the data


Range = the difference between the largest and smallest value of the data


Confidence Interval: (data must be normal)


There is 95% confidence that the population average is between _____ and ____ units.


Normal or significantly skewed data:


MegaStat: Descriptive statistics Normal curve goodness of fit p-value


· Normal, p-value > .05


· Significantly Skewed, p-value < .05


Histogram: Eyeball the histogram.


· Normal data will have a symmetrical or slightly skewed shape.


· Significantly Skewed shape will have extreme skewness


Use phrase combinations: Normally distributed: Mean and Standard Deviation, Not normally distributed: Median and IQR


Descriptive Statistics


Body Weight (Lbs.)


Central Tendency:


Mean = 149 Lbs.


Dispersion:


Standard deviation = 30 Lbs.


Count:


100


Min/Max:


99 pounds and 234 Lbs.


Confidence Interval:


144 to 155 Lbs.


See the histogram in Appendix A, and descriptive statistics in Appendix B.


Age


Distribution is not normally distributed


Central Tendency:


Median = 36 years


Dispersion:


Interquartile Range = 20.5 years / 2 = ± 10 years


Count:


100


Min/Max:


18 years and 74 years


Confidence Interval:


Not applicable (data is not normally distributed)


See the histogram in Appendix A, and descriptive statistics in Appendix B. A scatter plot is in Appendix C.


Education Level


Thirteen percent of the subjects have no high school degree while 44% have high school degree. Forty three percent have a college or college graduate degree. See the bar chart in Appendix D.


Descriptive Statistics Interpretation


Interpretation


Body Weight


One hundred subjects were randomly selected. Their body weight was observed between 99 and 234 pounds. Their average weight was 149 pounds, with a variation of plus or minus 30 pounds. One half or more were above 149 pounds. There is 95% confidence that the population body weight average is between 144 and 155 pounds.


Age


The data was significantly skewed. One hundred subjects were randomly selected. Their ages were between 18 and 74 years, with a variation of plus or minus 10 years. One half or more subjects were 36 years of age or older. The middle half of the subjects’ ages fell between 27 and 47 years. The most frequent age was 36 years.


APPENDIX A


Body Weight and Age Histograms






APPENDIX B


Descriptive Statistics Body Weight and Age




APPENDIX C


Scatterplot Body Age versus Weight




APPENDIX D


Bar Chart Education Level




Data Sets


The following chart shows the driving trend for Virginia from 2004 to 2014. The population for this data is licensed drivers. The sampling is alcohol related incidents for the past 11 years. The target population is all drivers that are of drinking age which is 21 years of age and older. However, the data provided does not include a breakout for underage drinkers. Further data is required in order to make a correlation between raising the alcohol tax rate and alcohol related incidents. As noted in the chart below, the number of incidents has decreased in the past 11 years. This consideration will also need to be included to determine if in fact there is a probability that the number of alcohol incidents will decrease by increasing the alcohol tax.


Note: Data extracted from the 2014 edition of Virginia Traffic Crash Facts.


From 2007 to 2013 Virginia’s tax rate per gallon has steadily increased with the exception of 2013 when tax rates decreased. These rate increases are a result of inflation and not targeted excise tax increases by the state. Recognizing Virginia is third in the nation when taxing spirits (namely liquor) it is also important to note Virginia is 31st in the nation when comparing tax rates for beer (Center for Science in the Public Interest).


(Tax Foundation, 2013)


When determining the correlation between drunken driving accidents and increases in alcohol tax rates first it must be determined if there are actual tax increases to compare the data. Using the proposed November 2014 increase in “case handling fees”, which raised the cost of an average bottle sold in Virginia by 20 cents, research can then be established to compare drunken driving crashes to any change in the number drunken driving accidents. As well as, whether the numbers increase or decrease as a direct correlation with the increase in costs in Virginia.


Reference


Center for Science in the Public Interest. (n.d.). States Ranked By Alcohol Tax Rates: Beer. Retrieved June 07, 2015, from cpsinet.org


Tax Foundation. (2013, April). State Excise Rates on Spirits, 2007-2013. Retrieved June 07, 2015, from Tax Foundation: taxfoundation.org/article/state-excise-tax-rates-2007-2013


Virginia Highway Safety Office. (2014). 2014 Virginia Traffic Crash Facts. Retrieved from


https://www.dmv.virginia.gov/safety/crash_data/crash_facts/crash_facts_14.pdf


Virginia Driving Trends


Alcohol Related


Crashes

2004 2005 2006 207 2008 2009 2010 2011 2012 2013 2014 11504 11495 11736 11215 10294 9366 8217 8411 8776 8047 7666


Year


Occurrences


Virginia Alcohol Tax Rate 2007-2013


Tax Rate 2007 2009 2010 2011 2013 14.54 19 20.13000000000001 20.91 20.56

Applied Sciences

Architecture and Design

Biology

Business & Finance

Chemistry

Computer Science

Geography

Geology

Education

Engineering

English

Environmental science

Spanish

Government

History

Human Resource Management

Information Systems

Law

Literature

Mathematics

Nursing

Physics

Political Science

Psychology

Reading

Science

Social Science

Home

Blog

Archive

Contact

google+twitterfacebook

Copyright © 2019 HomeworkMarket.com

Homework is Completed By:

Writer Writer Name Amount Client Comments & Rating
Instant Homework Helper

ONLINE

Instant Homework Helper

$36

She helped me in last minute in a very reasonable price. She is a lifesaver, I got A+ grade in my homework, I will surely hire her again for my next assignments, Thumbs Up!

Order & Get This Solution Within 3 Hours in $25/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 3 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 6 Hours in $20/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 6 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 12 Hours in $15/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 12 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

6 writers have sent their proposals to do this homework:

Top Essay Tutor
University Coursework Help
Helping Hand
Writer Writer Name Offer Chat
Top Essay Tutor

ONLINE

Top Essay Tutor

I have more than 12 years of experience in managing online classes, exams, and quizzes on different websites like; Connect, McGraw-Hill, and Blackboard. I always provide a guarantee to my clients for their grades.

$105 Chat With Writer
University Coursework Help

ONLINE

University Coursework Help

Hi dear, I am ready to do your homework in a reasonable price.

$102 Chat With Writer
Helping Hand

ONLINE

Helping Hand

I am an Academic writer with 10 years of experience. As an Academic writer, my aim is to generate unique content without Plagiarism as per the client’s requirements.

$100 Chat With Writer

Let our expert academic writers to help you in achieving a+ grades in your homework, assignment, quiz or exam.

Similar Homework Questions

Dead rising 1 all bosses and psychopaths - Technopoly - 200 hillside lane wardell - Discussion - Punchline algebra book b 13.16 answers - 25639 larkins street southfield mi - Trade discount formula business math - Swot analysis pixar - Buchbinder introduction to health care management - SCI 207 Week 3 Assignment 1, Ground and Surface Water Interactions(USE AS A GUIDE) - Awakenings movie questions and answers - Breezair evaporative cooler fault codes - Bemidji state university mascot - Creswell 2009 pdf - Profit Payoff Decision Role Play Activity - Into the wild vce - Service specification in iot - How does toyota market their products - Indian king used rolls royce as dustbin - Why do mergers and acquisitions sometimes fail to produce anticipated results? - Australian professional teaching standards - Early settlers food in canada - Ponce de leon ship - Ten duel commandments but everyone has issues - B and e marketplace - London whale jp morgan - Introduction to organizational - Wave on a string answer key - Double-bubble mind map - Ride with the mob hum do allah - Disney on ice corpus christi 2017 - Week 5 Slides , Dashboard/Outcome Report exercise - Tableau Visualization + Explanation, Dashboard or Outcome Report - Describe and explain - If an individual inserts a thumb drive containing classified information - Unilateral eccentric overloaded leg extension - Features of web 2.0 software as a service - Ladybug ladybug fly away home nancy drew - How does the cell membrane maintain stable internal conditions - The school of ethical universalism holds that - Vice presidential debate - Solving linear equations corbettmaths - The practice of BYOD by organizations creates many risks since users are accessing organizational networks with personal devices. - Understanding arguments an introduction to informal logic 9th edition pdf - Ibm academic initiative courseware - How to calculate theoretical yield recrystallization - How old was rebekah when she married isaac - ANY TYPE OF WRITTEN WORK - Hull theory vs Tulman Theory - The low tech’s ideal spot is - Unit VIII Journal - Conflict resolution in the workplace powerpoint - Hubspot case study solution - Article writing - Main points for informative speech - A heat engine receives heat from a source at - Whistleblower claims accounting shenanigans at successfactors - I NEED A PERSONAL WRITER TO HANDLE MY ASSIGNMENTS - Benchmark cert co uk - De montfort university library - Snap on solus ultra - Can you use scanpan on induction cooktops - How many platforms at flinders street station - August 2026 there will come soft rains summary - Examples of imaginary audience and personal fable - Distinguish between atomic number and mass number of an element - Group homework - Comrades marathon qualifying times - Uses of histogram in daily life - Comparative degree of hungry - Physics lab homework answers - Wgu leadership and communication reflection paper - Laramie wire manufacturing case - Percentage grades griffith university - Static and dynamic resistance of diode from graph - Rate law for h2o2 and ki - Speed and acceleration worksheet answers - Biblical response to euthanasia - Exaggerated praise crossword clue - Behavioural family therapy meriden - Arctic habitat shoebox project - Bsbhrm506 manage recruitment selection and induction processes answers - Preterite form of visitar - List the six hipaa defined permissions - First course on power electronics and drives - Project - Confidence interval for the population standard deviation aleks - Operating asset turnover formula - Scholastic book review template - Zhan's radcliffe on trent - Great western hospital address - What was net operating working capital for 2015 and 2016 - Documenting reality 9 11 - Express in power notation 16 81 - Psychotherapy a Biological Basis - Research and writing del 1 - How to make a mousetrap car step by step - Whitney houston eating disorder - Movie the rape of europa - Annotated Bibliography Assignment - Example of an employer association - ((gIrL-BoY+91-9829644411) Love Vashikaran Specialist Molvi Ji. In Ajmer