Explain and develop a regression model

Assignment Help Business Management

Reference no: EM1355083

Students in a management science class have just received their grades on the first test. The instructor has provided information about the first test grades in some previous classes as well as the final average for the same students. Some of these grades have been sampled and are as follows:

STUDENT 1 2 3 4 5 6 7 8 9
1st test grade 98 77 88 80 96 61 66 95 69
Final average 93 78 84 73 84 64 64 95 76

(a) Develop a regression model that could be used to predict the final average in the course based on the first test grade.

(b) Predict the final average of a student who made an 83 on the first test.

could you show using execl qm

Reference no: EM1355083

Questions Cloud

Explain how does a decrease in foreign price levels affect : EXplain how does a decrease in foreign price levels affect domestic aggregate expenditures and demand.

Organizations- analyzability as it applies to organizational : What is meant by the term analyzability as it applies to organizational design and what is service technology? What is meant by integrated enterprise and by data mining?

Ethical implications of a counselor : How do I explain the ethical implications of a counselor expressing their values to a client. How do I identify the options available to a counselor who is confronted with these issues.

Managerial accounting and organizational controls : Managerial Accounting and Organizational Controls at Deer Valley Lodge

Explain and develop a regression model : Explain and Develop a regression model that could be used to predict the final average in the course based on the first test grade.

Preliminary analytical procedures : Discuss how you would perform preliminary analytical procedures and recommend ways to mitigate engagement risk and audit risk.

Calculate the magnetic forece on the proton : A uniform magnetic field of magnitude B= 1.2 teslas is directed toward the bottom of the page in the -y direction as shown above. At time t=0, a proton p in field is moving in the plane of the page with a speed v0= 4 x 10^7 meters per second in a ..

Source of cash flows : Ratio measures the proportion of total assets financed by the firm's creditors - measure of a company's performance and condition.

Draw an ie crow-s foot e-r diagram for entities : Draw an IE Crow's Foot E-R diagram for the entities DEPARTMENT and EMPLOYEE and the 1:N relationship between them. Assume that a DEPARTMENT.

User Account

All Pages