Question 3: (Minitab or Excel – Excel is easiest) The table below shows the average distance...

Question 3: (Minitab or Excel – Excel is easiest)

The table below shows the average distance of each of the nine planets from the sun, and the length of the year (in earth years). Note that Pluto is not considered a planet anymore (check it out on Wikipedia).

Number	Position	Distance from Sun (million miles)	Length of Year in earth years
Mercury	1	36	0.24
Venus	2	67	0.61
Earth	3	93	1
Mars	4	142	1.88
Jupiter	5	484	11.86
Saturn	6	887	29.46
Uranus	7	1784	84.07
Neptune	8	2798	164.82
Pluto	9	3666	247.68

a) Plot the Length of the Year (the response) versus the Distance from the Sun (the explanatory variable). Describe the scatterplot.

b) Fit a linear model that will help predict the Length of Year a planet from its Distance from the Sun. Does the model provide a good fit?

c) Produce the residual plot for the model you developed in 3b. The plot shows a clear trend. Describe it. We are going to improve the model by re-expressing both distance and length of year in the logarithmic scale. This approach is indicated by the large amount of variance in both variables as well as strong positive skewness of their distributions (you can check both of these facts for yourself by making stemand-leaf plots and obtaining summary statistics—no need to include this step in your paper).

d) Take the base ten logarithm of the distance and length of year variables. We will refer to the new variable as the Log(distance) and Log(length). Follow the Minitab directions below on how to proceed.

e) Fit a regression line to predict Log(length) from Log(distance).

f) Obtain the residual plot for the model.

g) Did we improve the model?

Expert Solution

orchestra answered 1 year ago

EXCEL FILE ONLY Refer to the table below. The table below shows the annual returns (in...

EXCEL FILE ONLY Refer to the table below. The table below shows the annual returns (in percentages) for 2 major market indices. For each index, calculate the arithmetic mean return and the geometric mean return of full-year returns from 2005-2015. What is the relationship between the arithmetic and geometric mean returns? 2015 2014 2013 2012 2011 2010 2009 2008 2007 2006 2005 Nasdaq Composite Index 1.37 8.59 50.0 -31.5 -21.1 -39.3 85.6 39.6 21.6 22.7 39.9 Dow Jones Industrial Average...

The following table shows the average distance, to the nearest mile, travelled per week to work...

The following table shows the average distance, to the nearest mile, travelled per week to work by a random sample of 350 commuters. Miles Travelled Frequency Midpoint Class Boundaries 6 - 11 43 12 - 17 32 18 – 23 80 24 - 29 120 30 - 35 75 (a) Complete the table above. (b) What is the mean distance travelled per week by these commuters? (c) Why is the answer for part (b) an estimate of the mean distance...

The table below shows the average cost of a firm depending on the level of production....

The table below shows the average cost of a firm depending on the level of production. Q 0 1 2 3 4 5 6 AC -- 32 24 20 24 25 26 Assuming that the company is operating in the long run what are fixed costs?

Problem 3 Table 1 below shows an incomplete table of costs for a company. Use the...

Problem 3 Table 1 below shows an incomplete table of costs for a company. Use the definitions of these costs and how they are related to complete the missing cells of this table. For each cell you fill in, explain how you are able to determine the value of that cost. Table 1 – Costs Output (Q) Fixed Cost (FC) Variable Cost (VC) Total Cost (TC) Average Fixed Cost (AFC) Average Variable Cost (AVC) Average Total Cost (ATC) Marginal Cost...

Determine the Best Fit Linear Regression Equation Using Technology - Excel Question The table shows the...

Determine the Best Fit Linear Regression Equation Using Technology - Excel Question The table shows the age in years and the number of hours slept per day by 24 infants who were less than 1 year old. Use Excel to find the best fit linear regression equation, where age is the explanatory variable. Round the slope and intercept to one decimal place. Age Hours 0.03 16.5 0.05 15.2 0.06 16.2 0.08 15.0 0.11 16.0 0.19 16.0 0.21 15.0 0.26 14.5...

Table 3 (below) shows annual returns for the S&P 500 for the years 2000-2016: Table 3:...

Table 3 (below) shows annual returns for the S&P 500 for the years 2000-2016: Table 3: Annual Returns Year Returns 2000 -9.0% 2001 -11.9% 2002 -22.0% 2003 28.4% 2004 10.7% 2005 4.8% 2006 15.6% 2007 5.5% 2008 -36.6% 2009 25.9% 2010 14.8% 2011 2.1% 2012 15.9% 2013 32.2% 2014 13.5% 2015 1.4% 2016 11.7% Calculate: The cumulative return over the 17 years; The average annual return; The standard deviation; The Sharpe Ratio (assuming a risk free rate of 2.3% on...

Table below shows the demand for haircuts from seniors and other customers on an average weekday...

Table below shows the demand for haircuts from seniors and other customers on an average weekday in the local hairdressing shop. Price of Haircut Quantity Demanded by Seniors Quantity Demanded by Other Customers $24 1 9 22 4 10 20 7 11 18 10 12 16 13 13 14 16 14 12 19 15 10 22 16 8 25 17 6 28 18 a) Between the prices of $20 and $24, which of the two demands is more elastic? Round...

9. Problems and Applications Q3 The table below shows the annual average data on the employment...

9. Problems and Applications Q3 The table below shows the annual average data on the employment status of the U.S. civilian non-institutional population by age in 2015. Age Employed Unemployed Not in Labor Force (Thousands of People) (Thousands of People) (Thousands of People) 16 to 19 years 4,734 966 10,919 20 to 24 years 14,022 1,501 6,448 25 to 54 years 96,638 4,515 23,957 55 to 64 years 24,975 978 14,640 65 years and over 8,465 337 37,708 Total 148,834...

The table below shows the average weekly wages (in dollars) for state government employees and federal...

The table below shows the average weekly wages (in dollars) for state government employees and federal government employees for 10 years. Construct and interpret a 95% prediction interval for the average weekly wages of federal government employees when the average weekly wages of state government employees is $899. The equation of the regression line is y= 1.438x - 37.254 Wages (state) X 731 766 787 822 853 892 928 932 960 983 Wages (federal) Y 1,008 1.065 1,112 1,135 1,198...

The table given below shows how, on average, the market value of a Boeing 737 has...

The table given below shows how, on average, the market value of a Boeing 737 has varied with its age and the cash flow needed in each year to provide a 11% return. (For example, if you bought a 737 for $19.89 million at the start of year 1 and sold it a year later, your total profit would be 18.09 + 3.99 − 19.89 = $2.19 million, 11% of the purchase cost.) Assume airlines write off their aircraft straight-line...

Question