3. Wine Participant magazine has collected average price per bottle for the prestigious Chateau Le Thundebird bordeaux for different vintages (years).The data appears in the table below.year of bottlingpricea) draw the scatter diagram showing how wine price varies by vintage yearb) use the most appropriate regression equation to determine the relationshipbetween year of bottling (age) and price.c) what is the explanatory power (RSQ) of that equationd) determine the predicted price of a bottle of this wine for the 2017 vintage.200936201040201151201260201368201472201570201665201851201944202039

The data given is: Year of bottling(x) Price(y) 2009 36 2010 40 2011 51 2012 60 2013 68…

Answered: 3. Wine Participant magazine has…

MATLAB: An Introduction with Applications

6th Edition

ISBN:9781119256830

Author:Amos Gilat

Publisher:Amos Gilat

Chapter1: Starting With Matlab

Section: Chapter Questions

Problem 1P

See similar textbooks

Similar questions

We expect a car’s highway gas mileage to be related to its city gas mileage (in mpg). Data for all 1209 vehicles in the government’s 2016 Fuel Economy Guide give the regression line highway mpg=7.903+(0.993×city mpg) for predicting highway mileage from city mileage. (a) What is the slope of this line? (Enter your answer rounded to three decimal places.) slope: What does the numerical value of the slope tell you? For every 7.903 mpg in city gas mileage, highway gas mileage increases about 0.993 mpg. On average, highway mileage increases by 0.993 mpg for each additional mpg in city mileage. Highway gas mileage increases with city gas mileage by 7.903 mpg for each additional mpg in city mileage. On average, highway mileage decreases by 0.993 mpg for each additional mpg in city mileage. On average, highway mileage increases by 7.903 mpg for each additional mpg in city mileage. (b) What is the intercept? (Enter your answer rounded to three decimal…
Birthrates 2009 The table shows the number of livebirths per 1000 women aged 15–44 years in the United States, starting in 1965. (National Center for Health Sta-tistics, www.cdc.gov/nchs/) a) Make a scatterplot and describe the general trend in Birth-rates. (Enter Year as years since 1900: 65, 70, 75, etc.) b) Find the equation of the regression line.c) Check to see if the line is an appropriate model. Explain.d) Interpret the slope of the line.e) The table gives rates only at 5-year intervals. Estimatewhat the rate was in 1978.f) In 1978, the birthrate was actually 15.0. How close didyour model come?g) Predict what the Birthrate will be in 2010. Commenton your faith in this prediction.h) Predict the Birthrate for 2025. Comment on your faithin this prediction.
Part A: What is the most likely value of the correlation coefficient of the data in the table? Based on the correlation coefficient, describe the relationship between time and surface area of the lake. [Choose the value of the correlation coefficient from −1, −0.98, −0.5, −0.02.] Part B: What is the value of the slope of the graph of surface area versus time between 15 and 20 days, and what does the slope represent? Part C: Does the data in the table represent correlation or causation? Explain your answer.
You believe that the price of Zoom Videoconferencing stock and the price of American Airlines stock will move in opposite directions. In order to test this relationship, we do a simple regression with the following variables:A - dependent variable : month end price of American Airlines stockZ - independent variable: month end price of Zoom Videoconferencing stock Data from April 2019 through December 2020 (21 observations) is availableBased on the data, we compute the following:Var (Z) = 20927.702Cov (A,Z) = -899.153E(A) = 20.790E(Z) = 187.530Std Error of Estimate = 6.088TSS = 1476.830 Consider the equation At = b0 + b1 Zt + εtBased on the numbers given above, complete the following table Variable Estimate Std error t-statistic Slope b1 .00941 Constant b0 2.2088 R-square N/A N/A F statistic N/A N/A Are the coefficients (slope and/or constant) significant at the .05 level?
when a regression is used as a method of predicting dependent variables from one or more independent variables. How are the independent variables different from each other yet related to the dependent variable?
the following regression table where the dependent variable is the demandfor massage services in one city in the United States. Specifically, the dependent variable is the number of customers per hour (Models 1 and 2) or per day (Models 3 and 4). a) Explain why the coefficient for Population/1,000 in Model 2 is very different from the one in Model 4?
4. Housing Prices in New YorkWe have looked at predicting the price (in s) of New York homes based on the size (in thousands of square feet), using the data in HomesForSaleNY. Two other variables in the dataset are the number of bedrooms and the number of bathrooms. Use technology to create a multiple regression model to predict price based on all three variables: size, number of bedrooms, and number of bathrooms. Price Size Beds Baths 145 1.3 3 1.5 875 2.9 7 3.75 300 1.5 3 2.5 370 1.1 2 1 268 1.5 2 2 1399 4.8 6 5 1125 3.1 3 2.5 299 1.4 3 2 110 1.2 3 1 2999 6 7 8 170 1 2 1 269 1.5 3 1.5 150 1 2 1.5 288 1.8 3 2.1 350 1.3 3 2 120 0.9 1 1 309 2.4 4 2.5 1500 1.5 2 1.5 635 2.5 4 2.5 350 0.9 2 1 459 1.8 4 2.5 275 2.9 4 1.5 275 1.8 3 2 2500 3.7 3 3 187 1.4 3 1.5 238 1.7 3 1.5 155 0.7 1 1 175 1.6 3 1.5 569 3.2 4 2 105 1.2 2 2.5 a) Which of the variables which are significant at the 5% level? b) Which variable is the most…
Q1) A real estate consultant is considering developing a series of price models for residential houses in different areas of the province of Ontario, in Canada. The dataset, provided by the Windsor and Essex County Board, covers residential home sales in Windsor. To develop the model, the consultant performs a linear regression to estimate the price (in Canadian dollars) as a linear function of the size of the apartment (in square feet) and obtains the following Excel result. SUMMARY OUTPUT Regression Statistics Multiple R R Square Adjusted R Square Standard Error Observations 0.53580413 0.28708607 0.28577556 41101.9362 546 ANOVA df MS Significance F 1 3.70082E+11 3.7008E+11 219.065461 6.74643E-42 Regression Residual Total 544 9.19017E+11 1689369158 545 1.2891E+12 Coefficients Standard Error 62171.5874 4537.036582 13.7031268 6.2969E-37 53259.33066 71083.8441 t Stat P-value Lower 95% Upper 95% Intercept LOTSIZE 12.0187669 0.81203165 14.8008601 6.7464E-42 10.42366523 13.6138685 a) Write…
Used cars 2010 Vehix.com offered several used ToyotaCorollas for sale. The following table displays the ages ofthe cars and the advertised prices. a) Make a scatterplot for these data.b) Do you think a linear model is appropriate? Explain.c) Find the equation of the regression line. d) Check the residuals to see if the conditions for infer-ence are met. Age (yr) Price ($) Age (yr) Price ($)1 15988 6 99951 13988 6 119882 14488 7 89903 10995 8 94883 13998 8 89954 13622 9 59904 12810 10 41005 9988 12 2995
Q1: [Regression and Correlation] The index of biotic integrity (IBI) is a measure of water quality in streams. As a data analyst you must monitor, track, and predict changes in water quality. You want to create a simple linear regression model that will allow you to predict changes in IBI in forested area. The following table conveys sample data from a coastal forest region and gives the data for IBI and forested area in square kilometers. Let forest area be the predictor variable (x) and IBI be the response variable (y). IBI X 47 72 21 72234 19 58 49 Forest Area Y 38 59 27 24 63 49 45 Required a. Q2: [Naïve Bayes] a. Write the pseudo-code of the following Naïve Bayes algorithm b. Consider the given dataset that classifies animals into two distinct classes. The classes are labeled as 'cat' and 'dog'. Use Naive Bayes classifier to figure out the class (cat/dog) of an instance if it has the following values of attributed Plot Scatter graph b. Determine the regression equation c. Compute…
Seedlings of understory trees in mature tropical rainforests must survive and grow using intermittent flecks of sunlight. How does the length of exposure to these flecks of sunlight (fleck duration) affect growth? Researchers experimentally irradiated seedlings of the Southeast Asian rainforest tree with flecks of light of varying duration while maintaining the same total irradiance to all the seedlings. Below is the data. Fit a linear model to the data. Tree Mean Fleck (min) Relative growth rate (mm/mm/week 1 3.4 0.013 2 3.2 0.008 3 3 0.007 4 2.7 0.005 5 2.8 0.003 6 3.2 0.003 7 2.2 0.005 8 2.2 0.003 9 2.4 0 10 4.4 0.009 11 5.1 0.01 12 6.3 0.009 13 7.3 0.009 14 6 0.016 15 5.9 0.025 16 7.1 0.021 17 8.8 0.024 18 7.4 0.019 19 7.5 0.016 20 7.5 0.014 21 7.9 0.014 a)What is the rate of change in relative growth…
One of the biggest changes in higher education in recent years has been the growth of online universities. The Online Education Database is an independent organization whose mission is to build a comprehensive list of the top accredited online colleges. The following table shows the retention rate (%) and the graduation rate (%) for 29 online colleges.a). Use Excel Data Analysis Tool – Regression to get the relationship between the two variables;b). Create a scatter diagram for the two variables and display regression equation and R square on chart, then explain the relationship between the variables;c). Did the estimated regression equation provide a good fit?d). Suppose you were the president of South University. After reviewing the results, would you be able to use the regression result for forecasting. College RR(%) GR(%) Western International University 7 25 South University 51 25 University of Phoenix 4 28 American InterContinental University 29 32 Franklin…

SEE MORE QUESTIONS

Recommended textbooks for you

MATLAB: An Introduction with Applications

Statistics

ISBN:

9781119256830

Author:

Amos Gilat

Publisher:

John Wiley & Sons Inc

Probability and Statistics for Engineering and th…

Statistics

ISBN:

9781305251809

Author:

Jay L. Devore

Publisher:

Cengage Learning

Statistics for The Behavioral Sciences (MindTap C…

Statistics

ISBN:

9781305504912

Author:

Frederick J Gravetter, Larry B. Wallnau

Publisher:

Cengage Learning

MATLAB: An Introduction with Applications

Statistics

ISBN:

9781119256830

Author:

Amos Gilat

Publisher:

John Wiley & Sons Inc

Probability and Statistics for Engineering and th…

Statistics

ISBN:

9781305251809

Author:

Jay L. Devore

Publisher:

Cengage Learning

Statistics for The Behavioral Sciences (MindTap C…

Statistics

ISBN:

9781305504912

Author:

Frederick J Gravetter, Larry B. Wallnau

Publisher:

Cengage Learning

Elementary Statistics: Picturing the World (7th E…

Statistics

ISBN:

9780134683416

Author:

Ron Larson, Betsy Farber

Publisher:

PEARSON

The Basic Practice of Statistics

Statistics

ISBN:

9781319042578

Author:

David S. Moore, William I. Notz, Michael A. Fligner

Publisher:

W. H. Freeman

Introduction to the Practice of Statistics

Statistics

ISBN:

9781319013387

Author:

David S. Moore, George P. McCabe, Bruce A. Craig

Publisher:

W. H. Freeman

SEE MORE TEXTBOOKS