(Can U see the Excel attached file?, cos it seems its only picture that can be attached). If so, send me an email address so I can send Excel file).

Assignment 1

The President's Inn Guest Database provides a list of customers, rooms they occupied, arrival and departure dates, number of occupants, and daily rate for a small bed-and-breakfast inn during one month. 4 Room rates are the same for one or two guests; however, additional guests must pay an additional $20 per person per day for meals. Guests staying for seven days or more receive a 10% discount. Modify the spreadsheet to calculate the number of days that each party stayed at the inn and the total revenue for the length of stay. Calculate the total sum of revenue from the bookings in the database.

The Microprocessor data shows the demand for one type of chip used in industrial equipment from a small manufacturer.

• Construct a chart of the data. What appears to happen when a new chip is introduced?
• Develop a regression model to forecast demand that includes both time and the introduction of a new chip as explanatory variables.
• What would the forecast be for the next month if a new chip is introduced? What would it be if a new chip is not introduced?

The 2016 Sales data contains customers' historical annual sales and their Christmas spend.

• Build a model to estimate upcoming Christmas spend based on their annual sales.
• Evaluate the goodness of fit; try to improve the model's fit to over 90%.

SAT is a standardized test for high school students. The SAT data is a study that examines the SAT and GPA information of 105 students who graduated from a university with a B.S. in computer science. As an advisor to the Admission Officer, you want to accept student applicants that have the high potential to excel in university.

• Can you predict a student's college grades using the grades and test scores from high school?
• What variables should or should not be included? Be sure to think about what variables are available at the time of application. Do not include if it is not available in highschool years. What is the final model?
• What is the minimum requirement to get university GPA above 3?

Variable Description

• high_GPA High school grade point average
• math_SAT Math SAT score
• verb_SAT Verbal SAT score
• comp_GPA University Computer science program grade point average
• univ_GPA Overall university grade point average

SEND ME AN EMAIL TO SEND THE EXCEL FILE>