I NEED TO ANSWER BY HAND NOT EXCEL

Use the following information to answer the following questions: Five countries are listed in the table below. To the right of each is the male cigarette consumption per capita in 1930 and the male death rate from lung cancer 20 years later in 1950. Also included is the standard deviation of the numbers in each column. All numbers are rounded off to make calculations less laborious. Some calculations have been completed for you.

COUNTRY	MALE PER CAPITA CIGARETTE CONSUMPTION	MALE DEATH RATE (PER MILLION)
Australia	500	170
united states	1300	190
japan	900	180
canada	500	150
sweden	300	110
Standard Deviation	400	30.6
r = 0.830

A. Calculate the best-fitting regression equation for this data set, and report that equation below.

B. Calculate the standard error of prediction for the regression equation.

C. Interpret your result. (What does the number that you found above mean in very general terms?)

D. Calculate the coefficient of determination and interpret your result.

E. Now imagine that a friend tells you about a country named Tobbaccia where all of the residents were addicted to cigarettes in 1930. The male cigarette consumption per capita in Tobbaccia was 3500 in 1930. What would you tell your friend if she wanted you to predict the male death rate from lung cancer in Tobbaccia in 1950?

F. The cigarette consumption per capita was 1100 in Great Britain in 1930. Estimate the male death rate from lung cancer in Great Britain in 1950 with a confidence interval. The answer has been started for you.

G. My best prediction is a death rate equal to ________.

H. I am 95% confident that the correct male death rate falls between ______ and _______.

I. From your statistical analysis alone, what can you conclude would happen if Great Britain reduced the average cigarette consumption for males?