Develop regression model to predict the total tuition

Assignment Help Operation Management

Reference no: EM133961462

Question

A sample of eighteen universities was taken. The total cost for the year (including room and board) and the median SAT score (maximum total is 2400) at each school were recorded. It was felt that school with higher median SAT scores would have a better reputation and would charge more tuition as a result of that. The data are in the file named "HW3_Problem3_Data".

1. Develop a regression model to predict the total tuition and fees based on SAT scores. show hand computation by showing all the computational steps. See "Lecture 11" slides 14-19. Do NOT use the Excel Regression function.

2. Use the model from part (a) to predict the total cost for a university with a median SAT score of 1900. Make sure to retain all the formulas in the excel worksheet.

Reference no: EM133961462

Questions Cloud

Product design within operations management environment : Create a product design within an operations management environment, using real world research to support your work.

What are the advantages over Python and Java : This includes its purpose and use, benefits and problems, any industry or functional use. What are the advantages over Python and Java?

Companies should plan procurement for ppe kits : Do you think companies should plan procurement for PPE kits for future pandemics? What should be the procurement strategy

How does data security portrayed creatively in society : How does Data security issue interact with the history lens and impact social issues? How does Data security portrayed creatively in society?

Develop regression model to predict the total tuition : Develop a regression model to predict the total tuition and fees based on SAT scores. show hand computation by showing all the computational steps.

What is understand by lean production system : What are the various types of wastes in the production systems? What is understand by Lean Production System?

Identify factors in decision-making environment : Identify factors in a decision-making environment. Interpret decisions made under uncertainty. Why did you choose the two strategies?

Framework or programme theory : Logic model is sometimes called M&E framework or programme theory, and this has five essential components namely, inputs, processes, outputs,

What are the benefits of using control charts : What are the benefits of using control charts? Distinguish between nonconformity and a nonconforming item.

User Account

All Pages