# Explain the relationships according to your plots.

You need Excel, Analytic Solver and R up and running on your computers. I uploaded a practice problem (see Quizzes on the left panel) to give you an idea about what kind of problems you may expect. The questions will be open ended to test your ability to synthesize different concepts (see the practice problem in Quizzes module). There will be three questions: one covers data visualization and descriptive multiple linear regression; one covers predictive multiple linear regression; and the last one covers predictive logistic regression and KNN. For the first two questions, you are allowed to use either R or Analytic Solver. For the last question, you will use Analytic Solver.
For each problem you have to show your work otherwise no credit will be given. For each problem you have to upload the following files (all files for each problem are mandatory):
If you used Analytic Solver, an Excel spreadsheet for each problem (call them ‘Problem1.xlsx’, ‘Problem2.xlsx’ and ‘Problem3.xlsx’) that will be composed of as many sheets as needed to answer all the questions relevant to each problem. Make sure to name each sheet reflecting the question number (for example Q1 for question 1, Q2 for question 2 in Problem 1 etc.
If you used R, compile the R script to an html file. Submit both the script and the html file. Use descriptive names as explained above.
Q1:Descriptive Multiple Linear Regression:
You work at a consulting firm specializing in improving productivity at manufacturer facilities. Your director provided you with a data set Download data setthat includes information on several manufacturing facilities. She asked you to determine what factors affect scrap rate at these facilities. Scrap rate is a proxy for production quality and output. A lower scrap rate is desirable. Analyze this data set by answering the following questions. You can use Excel, Analytic Solver or R.
a)Create appropriate visualizations to investigate how scrap rate is related to number of employees at a plant, sales, whether the facility is unionized or not, and the number of different products manufactured at the facility. Explain the relationships according to your plots.
b)Find the mean, the standard deviation and the skewness of the scrap rate for the unionized and nonunionized facilities. Interpret these summary statistics by comparing them.
c)Find pairwise correlations of the variables with scrap rate in your data set. Show all your work and interpret the correlations.
d)Build a regression model to explain the relationship of scrap rate with the various predictors in the data set. Interpret the regression coefficients and model fit in detail. Consider including quadratic terms as needed. Be as descriptive as possible. Show all your work.
e)You think the facilities workers with a number of workers between 20 and 30 has a lower scrap rate than the facilities with less than 20 workers and more than 30 workers. Can you test this ? (Hint: Read “Categorical variables with Multiple Categories” Section of your textbook on page 218.)
f)Using a boxplot of scrap rate, remove all the outliers. Compare the average scrap rate before and after removing the outliers.
Question2:
You set out to build a predictive multiple linear regression model to predict the prices of houses listed on AirBnB. You have a data set Download data setthat includes information on price per day and various predictors. You decided to use the holdout method. The partition column in the dataset indicates which observations belong to the training sample (t) and which ones belong to the validation sample (v). You can use either Analytic Solver or R.
Using exhaustive search, and adjusted R^2 to evaluate model fit, find a candidate model to use for prediction
Using backward search, and Mallow’s Cp to evaluate model fit, find a candidate model to use for prediction.
Which of these two models is the best for predicting prices? Justify your answer. Report all your work clearly.
Question3:
You are working as a loan analyst at Goods-Fargo Bank. You decided to create a tool to determine whether a loan applicant would repay a loan he/she received. You have a data set Download data setwith several customer variables and whether a customer repaid (Repay variable) the loan.
Use the holdout method and Partition variable to create training and validation samples. Use Analytic Solver for this question.
a)Use logistic regression to predict who is likely to repay the loan. Evaluate the following two models in terms of their prediction accuracy. In the first model, use all the predictors, i.e., full model. In the second model, use 8 predictors. For the second model, you are free to choose which predictors to leave out. Then evaluate these two candidate models based on their overall classification accuracy. Recommend a final model and express the model as a mathematical equation relating the output variable to the input variables.
b)Use a k-NN model to predict who would repay the loan. Recommend a final model by carefully stating model parameters such as k and cutoff probability. How does this model perform compared to the final model in part 1?

# What Will You Get?

We provide professional writing services to help you score straight A’s by submitting custom written assignments that mirror your guidelines.

Get result-oriented writing and never worry about grades anymore. We follow the highest quality standards to make sure that you get perfect assignments.

#### Experienced Writers

Our writers have experience in dealing with papers of every educational level. You can surely rely on the expertise of our qualified professionals.

#### On-Time Delivery

Someone from our customer support team is always here to respond to your questions. So, hit us up if you have got any ambiguity or concern.

#### Complete Confidentiality

Sit back and relax while we help you out with writing your papers. We have an ultimate policy for keeping your personal and order-related details a secret.

#### Authentic Sources

We assure you that your document will be thoroughly checked for plagiarism and grammatical errors as we use highly authentic and licit sources.

#### Moneyback Guarantee

Still reluctant about placing an order? Our 100% Moneyback Guarantee backs you up on rare occasions where you aren’t satisfied with the writing.

#### Order Tracking

You don’t have to wait for an update for hours; you can track the progress of your order any time you want. We share the status after each step.

#### Areas of Expertise

Although you can leverage our expertise for any writing task, we have a knack for creating flawless papers for the following document types.

# Trusted Partner of 9650+ Students for Writing

From brainstorming your paper's outline to perfecting its grammar, we perform every step carefully to make your paper worthy of A grade.

##### Preferred Writer

Hire your preferred writer anytime. Simply specify if you want your preferred expert to write your paper and we’ll make that happen.

##### Grammar Check Report

Get an elaborate and authentic grammar check report with your work to have the grammar goodness sealed in your document.

##### One Page Summary

You can purchase this feature if you want our writers to sum up your paper in the form of a concise and well-articulated summary.

##### Plagiarism Report

You don’t have to worry about plagiarism anymore. Get a plagiarism report to certify the uniqueness of your work.

## Free Features \$66FREE

• Most Qualified Writer \$10FREE
• Plagiarism Scan Report \$10FREE
• Unlimited Revisions \$08FREE
• Paper Formatting \$05FREE
• Cover Page \$05FREE
• Referencing & Bibliography \$10FREE
• Dedicated User Area \$08FREE

#### Our Services

• On-time Delivery

We create perfect papers according to the guidelines.

##### Professional Editing

We seamlessly edit out errors from your papers.

Work with ultimate peace of mind because we ensure that your academic work is our responsibility and your grades are a top concern for us!

# Check Out Our Sample Work

Dedication. Quality. Commitment. Punctuality

Categories
All samples
Essay (any type)
Essay (any type)
Two Effects of Daily Exercise on Mental Health
English 101
1

# It May Not Be Much, but It’s Honest Work!

Here is what we have achieved so far. These numbers are evidence that we go the extra mile to make your college journey successful.

# Process as Fine as Brewed Coffee

We have the most intuitive and minimalistic process so that you can easily place an order. Just follow a few steps to unlock success.

# See How We Helped 9000+ Students Achieve Success

#### We Analyze Your Problem and Offer Customized Writing

We understand your guidelines first before delivering any writing service. You can discuss your writing needs and we will have them evaluated by our dedicated team.

• Clear elicitation of your requirements.
• Customized writing as per your needs.

#### We Mirror Your Guidelines to Deliver Quality Services

We write your papers in a standardized way. We complete your work in such a way that it turns out to be a perfect description of your guidelines.

• Proactive analysis of your writing.
• Active communication to understand requirements.