Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

1. Building a regression model a) Use Excel to build a linear regression model predicting the tip percent using all of the other columns in

image text in transcribed
1. Building a regression model a) Use Excel to build a linear regression model predicting the tip percent using all of the other columns in the file. Output the results to a new sheet. Show a screenshot of the regression output. b) Import the dataset into RapidMiner, making sure to change the role of Tip Percent to "label.\"I Use the Linear Regression operator to build a linear regression model to predict tip percent, setting the feature selection parameter to "none." Show a screenshot of the regression output. (Hint: the coefficients and p-values should be the same for a and b, except for differences in formatting and rounding.) 2. Evaluating regression models a) Which independent variable(s) are significant in your regression model from Part 1? b) The linear regression model in Part 1a is clearly significant, i.e. using Net Sales, Qty, Percent Coffee, and Percent Gelato to predict Tip Percent is clearly better than simply predicting the average Tip Percent for every customer. However, R Square is only 0.0136. Why is R Square so low despite the model being significant; how can those two things both be true

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Entrepreneurship

Authors: Andrew Zacharakis, William D Bygrave

5th Edition

1119563097, 9781119563099

Students also viewed these Mathematics questions