04.30

pdf

School

Utah State University *

*We aren’t endorsed by this school

Course

3100

Subject

Statistics

Date

Apr 3, 2024

Type

pdf

Pages

Uploaded by DrMetal9439

DATA 3100 | Making Decisions with Data Module 4: Homework Set 3 + Excel Set 2 Name: Homework Set 3 Answer the below problems from the textbook, and be sure to show your work. You will be assessed on demonstrating your knowledge. See Canvas for more details. 2.35 3.2+2.5+2.1+3.7+2.8+2/6= 2.71 Mean 2.0 2.1 2.5 2.8 3.2 3.7 – 2.65 Median 2.36 a. 85/10 = 8.5 b. 400/16 = 25 c. 35/45 = 0.78 d. 242/18 = 13.4 2.40 a. 7+-2+3+3+0+4/6 = 2.5 Mean -2, 0, 3, 3, 4, 7 = 3 Median 3 = Mode b. 2+3+5+3+2+3+4+3+5+1+2+3+4/13 = 3.07 Mean 1, 2, 2, 2, 3, 3, 3, 3, 3, 4, 4, 5, 5 = 3 Median 3 = Mode c. 51+50+47+50+48+41+59+68+45+37/10 = 49.6 Mean 37, 41, 45, 47, 48, 50, 50, 51, 59, 68 = 49 Median 50 = Mode 2.41 a. Mean < Median b. Mean > Median c. Mean would equal median

DATA 3100 | Making Decisions with Data Module 4: Homework Set 3 + Excel Set 2 2.51 – Skip F a. Skewed right, due to the high executive level positions such as president or department heads that would have higher income than most faculty. b. Skewed left, most students would assumably score high and then the few outliers would be the low end. c. Skewed right, most students would score poorly, but the few who scored high would bring the mean up. d. Symmetrical, I imagine that for every student that did no studying there was one that did lots of studying and everything in between. e. Skewed left, assuming that used car lots would have more older vehicles than brand new or even just a few years old. Excel Set 2 Answer the below problems from the textbook. In this template doc, provide your written responses and any requested formulas from your Excel file. Upload both your Excel file and this completed document to the Canvas assignment page by its due date/time. 2.46 After reading Exercise 2.46 in the text, you can optionally copy the table shown in the textbook into Excel in the first worksheet (Sheet 1) to answer the questions. 2.46A The mean of the Attach samples was significantly lower than that of the normal, given the higher max we can assume there was a few outlying data points but for the attacking samples most happened around the ~250-275 range, unlike the normal data, showing the opposite, of low outliers and higher data points. 2.46B

DATA 3100 | Making Decisions with Data Module 4: Homework Set 3 + Excel Set 2 The medians are both lower than the means, meaning that there were a few higher data points that would draw the mean up, but showing the median being closer to the ~200-230 range gives better description of what the data set really looks like. 2.46C I would make the conclusion for both data sets, the graphs would be skewed right, with the bulk of the data points in the ~200-250 range but each sample having a few high outlying points to bring the means up. 2.49 After reading Exercise 2.49 in the text, you will need to copy the HCOUGH.xlsx dataset on Canvas – NOT the data in the textbook table – into Excel in a worksheet (Sheet 2) to answer the questions. 2.49A - 11

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

DATA 3100 | Making Decisions with Data Module 4: Homework Set 3 + Excel Set 2 2.49B - 9 2.49C - 7 2.49D There is reasonable conclusion that honey had a higher improvement score compared to over the counter medicine and a control, leading to say that honey is a better cough medicine. Excel Doc Also upload your Excel doc along with this template!

Related Documents

HW3 completed.docx

Exam 3 Study Guide With Answers.docx

Lab Instructions_ Data Analysis Mission Memo (Spring A 2024 Onward).docx

worksheet 1.pdf

Worksheet 03.pdf

05.30 HW.doc

03.30Homework Set 2 .docx

Test 2_Key.pdf

Exam2_Review2.pdf

Assignment 7.pdf

Lab Report Statistical Analysis on Genetic Data - Rayana Rankoussi (1).docx

IDS 575 PS3.pdf

Recommended textbooks for you

Glencoe Algebra 1, Student Edition, 9780079039897...

Algebra

ISBN:9780079039897

Author:Carter

Publisher:McGraw Hill

Holt Mcdougal Larson Pre-algebra: Student Edition...

Algebra

ISBN:9780547587776

Author:HOLT MCDOUGAL

Publisher:HOLT MCDOUGAL

Big Ideas Math A Bridge To Success Algebra 1: Stu...

Algebra

ISBN:9781680331141

Author:HOUGHTON MIFFLIN HARCOURT

Publisher:Houghton Mifflin Harcourt

Algebra: Structure And Method, Book 1

Algebra

ISBN:9780395977224

Author:Richard G. Brown, Mary P. Dolciani, Robert H. Sorgenfrey, William L. Cole

Publisher:McDougal Littell

Elementary Geometry for College Students

Geometry

ISBN:9781285195698

Author:Daniel C. Alexander, Geralyn M. Koeberlein

Publisher:Cengage Learning

Elementary Geometry For College Students, 7e

Geometry

ISBN:9781337614085

Author:Alexander, Daniel C.; Koeberlein, Geralyn M.

Publisher:Cengage,

SEE MORE TEXTBOOKS

Recommended textbooks for you

Glencoe Algebra 1, Student Edition, 9780079039897...
Algebra
ISBN:9780079039897
Author:Carter
Publisher:McGraw Hill
Holt Mcdougal Larson Pre-algebra: Student Edition...
Algebra
ISBN:9780547587776
Author:HOLT MCDOUGAL
Publisher:HOLT MCDOUGAL
Big Ideas Math A Bridge To Success Algebra 1: Stu...
Algebra
ISBN:9781680331141
Author:HOUGHTON MIFFLIN HARCOURT
Publisher:Houghton Mifflin Harcourt
Algebra: Structure And Method, Book 1
Algebra
ISBN:9780395977224
Author:Richard G. Brown, Mary P. Dolciani, Robert H. Sorgenfrey, William L. Cole
Publisher:McDougal Littell
Elementary Geometry for College Students
Geometry
ISBN:9781285195698
Author:Daniel C. Alexander, Geralyn M. Koeberlein
Publisher:Cengage Learning
Elementary Geometry For College Students, 7e
Geometry
ISBN:9781337614085
Author:Alexander, Daniel C.; Koeberlein, Geralyn M.
Publisher:Cengage,