contains a set of data that describes a functional relationship between the dependent variable y and the independent variable x. Construct a line chart of each data set and use the Trendline tool to determine the best-fitting functions to model these data sets. Do not consider polynomials beyond the third degree.
1
Using the Excel file Weddings, apply the Regression ad uting the as ding cop as the dearinden variable
a. What is the regression model?
b. Interpret all key regression results, hypothesis tests, and confidence intervals in the output.
c. If a couple is planning a wedding for 175 guests, how much should they budget?
2.
Using the data in the Excel file Home Market Value, find the best multiple linear regression model for estimating the market value as a function of both the age and size of the house. Predict the value of a house that is 30 years old and has 1,800 square feet, and one that is 5 years old and has 2,800 square feet.