1. The following data records cigarette smoking and death rates due to leukemia in 14 states. We want to see if there are relationships between the number of cigarettes smoked and death due to leukemia. Deaths per year per 100,000 people State Cigarettes per person Leukemia California 2860 7.06 Idaho 2010 6.62 Illinois 2791 7.27 Indiana 2618 7.00 Iowa 2212 7.69

Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:James Kurose, Keith Ross
Chapter1: Computer Networks And The Internet
Section: Chapter Questions
Problem R1RQ: What is the difference between a host and an end system? List several different types of end...
icon
Related questions
Question

Make a spreadsheet on excel and show the procedure of every step mentioned in the images.

1. The following data records cigarette smoking and death rates due to leukemia in 14 states. We
want to see if there are relationships between the number of cigarettes smoked and death due to
leukemia.
Deaths per year per 100,000 people
State
Cigarettes per person
Leukemia
California
2860
7.06
Idaho
2010
6.62
Illinois
2791
7.27
Indiana
2618
7.00
Iowa
2212
7.69
Kansas
2184
7.42
Kentucky
Massachusetts
2344
6.41
2692
6.89
Minnesota
2206
8.28
New York
2914
7.23
Alaska
3034
4.90
Nevada
4240
6.67
Utah
1400
6.71
Texas
2257
7.02
Conduct the follow analysis for cigarettes vs. leukemia.
a) Plot the scatter diagram.
b) Find m, b, and the linear regression line and add it to the graph.
c) Find the coefficient of correlation between cigarettes and leukemia. Is there a strong linear
correlation? (Write your answer in the spreadsheet.)
d) Explore better models: find the exponential, quadratic and cubic models. Adjust the precision of
the formulas if needed. Choose reasonable number of significant figures to show in the results.
e) Find the sum of the squared residuals for each estimate, including the linear model. Which is the
best fit? Why? (Write your answers in the spreadsheet.)
Transcribed Image Text:1. The following data records cigarette smoking and death rates due to leukemia in 14 states. We want to see if there are relationships between the number of cigarettes smoked and death due to leukemia. Deaths per year per 100,000 people State Cigarettes per person Leukemia California 2860 7.06 Idaho 2010 6.62 Illinois 2791 7.27 Indiana 2618 7.00 Iowa 2212 7.69 Kansas 2184 7.42 Kentucky Massachusetts 2344 6.41 2692 6.89 Minnesota 2206 8.28 New York 2914 7.23 Alaska 3034 4.90 Nevada 4240 6.67 Utah 1400 6.71 Texas 2257 7.02 Conduct the follow analysis for cigarettes vs. leukemia. a) Plot the scatter diagram. b) Find m, b, and the linear regression line and add it to the graph. c) Find the coefficient of correlation between cigarettes and leukemia. Is there a strong linear correlation? (Write your answer in the spreadsheet.) d) Explore better models: find the exponential, quadratic and cubic models. Adjust the precision of the formulas if needed. Choose reasonable number of significant figures to show in the results. e) Find the sum of the squared residuals for each estimate, including the linear model. Which is the best fit? Why? (Write your answers in the spreadsheet.)
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 5 images

Blurred answer
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Concepts of Database Management
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY