05.30 HW

doc

School

Utah State University *

*We aren’t endorsed by this school

Course

3100

Subject

Statistics

Date

Apr 3, 2024

Type

doc

Pages

Uploaded by DrMetal9439

DATA 3100 | Making Decisions with Data Module 5: Homework Set 4 + Excel Set 3 Name: Andrew Carley Homework Set 4 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.57 2.71 a. Units of measurement are $$, and this data is quantitative. b. 900-2100 is within 2SD. 600-2400 is within 3 SD and would be considered outliers. 1200-1800 would be within 1 SD and be at least 75%. 2.74 a. Mean = 8.05, Stand Dev = 1.83, S^2= 3.35 b. (6.22-9.88) = 60% (4.39-11.71) = 96% (2.56-13.54) = 100%

DATA 3100 | Making Decisions with Data Module 5: Homework Set 4 + Excel Set 3 c. This data does not follow the empirical rule with only 60% of the data falling within 1 SD, but does follow Chebyshev’s inequality, meaning on a graph this data would be somewhat skewed or non-bell shaped. d. Range (5-12)/4 = 1.75, which is close to the S we found in a. 2.90 a. (40-30)/5 = 2, sample, above mean by 2 SD b. (90-89)/2 = 0.5, sample, above mean by .5SD c. (50-50)/5 = 0, sample, right on mean d. (20-30)/4 = -2.5, population, below mean by 2.5SD 2.91 a. 75% below, 25% above b. 50% below, 50% above c. 20% below, 80% above d. 84% below, 16% above 2.92 QL = Lower quartile = first 25% of measurements, QM = middle quartile = the median, QU upper quartile = top 25% of measurements. 2.106 a. No b. Yes c. No d. Yes 2.107

DATA 3100 | Making Decisions with Data Module 5: Homework Set 4 + Excel Set 3 2.108 a. 4 b. 3,6 c. 3-6 = 3 d. Skewed right e. 50% right, 25% left f. 12, 13, 16 Excel Set 3 Answer the below problems from the textbook. For each problem, use the dataset on Canvas, not the table in the textbook . In this template doc, provide your written responses and screenshots from your Excel file. Upload both your Excel file and this completed document to the Canvas assignment page by its due date/time. 2.66 After reading Exercise 2.66 in the text, you will need to copy the SCREEN.xlsx dataset from Canvas into Excel in the first worksheet (Sheet 1) to answer the questions. Do NOT use the data table in the textbook.

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 5: Homework Set 4 + Excel Set 3 2.68 After reading Exercise 2.68 in the text, you will need to copy the HCOUGH.xlsx dataset from Canvas into your Excel document and paste it into a new worksheet (Sheet 2) to answer the questions. Do NOT use the data table in the textbook. 2.68D DM has the most variance, with Honey having the least variance. 2.81 After reading Exercise 2.81 in the text, you will need to copy the SANIT.xlsx dataset from Canvas into your Excel document and paste it into a new worksheet (Sheet 3) to answer the questions. Do NOT use the data table in the textbook. 2.98 After reading this exercise in the text, you will need to copy the SANIT.xlsx dataset from Canvas into your Excel document and paste it into a new worksheet (Sheet 4) to answer the questions. Do NOT use the data table in the textbook.

DATA 3100 | Making Decisions with Data Module 5: Homework Set 4 + Excel Set 3 2.98C (Additional Questions) What is the first (lower) quartile of this dataset? What is the middle quartile of this dataset? What is the third (upper) quartile of this dataset? What is the 90th percentile of this dataset? First Quartile is 92.5, Third Quartile is 98. 2.117 After reading this exercise in the text, you will need to copy the SANIT.xlsx dataset from Canvas into your Excel document and paste it into a new worksheet (Sheet 5) to answer the questions. Do NOT use the data table in the textbook. 2.117 Pre 2.117A

DATA 3100 | Making Decisions with Data Module 5: Homework Set 4 + Excel Set 3 Outlier is the 79. 2.117B The only outlier is the 79. 2.117C Yes the two methods agree. 2.159 Submit Excel Doc Also upload your Excel doc along with this template!

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

Related Documents

HW6-solutions.html

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

04.30.pdf

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

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

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

College Algebra (MindTap Course List)

Algebra

ISBN:9781305652231

Author:R. David Gustafson, Jeff Hughes

Publisher:Cengage Learning

Elementary Algebra

Algebra

ISBN:9780998625713

Author:Lynn Marecek, MaryAnne Anthony-Smith

Publisher:OpenStax - Rice University

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

Algebra

ISBN:9781680331141

Author:HOUGHTON MIFFLIN HARCOURT

Publisher:Houghton Mifflin Harcourt

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
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
College Algebra (MindTap Course List)
Algebra
ISBN:9781305652231
Author:R. David Gustafson, Jeff Hughes
Publisher:Cengage Learning
Elementary Algebra
Algebra
ISBN:9780998625713
Author:Lynn Marecek, MaryAnne Anthony-Smith
Publisher:OpenStax - Rice University
Big Ideas Math A Bridge To Success Algebra 1: Stu...
Algebra
ISBN:9781680331141
Author:HOUGHTON MIFFLIN HARCOURT
Publisher:Houghton Mifflin Harcourt