Please give an explanation for each answer. Q5 If you want to draw a linear regr
ID: 390670 • Letter: P
Question
Please give an explanation for each answer.
Q5 If you want to draw a linear regression line on the Excel spreadsheet, you can use the following command to easily draw the line: 1. Solver 2. R-squared 3. trendline 4. sumproduct0) 5. sumxmy20) Q6 When we observe a congestion in a service system, the dynamic pricing scheme may be used. Why is the dynamic pricing strategy considered to be effective? 1. 2. 3. Because it can control demand. . Because it can control trend. 5. Because it is inexpensive. Because it can control supply Because it uses an efficient information technology Q7 Productivity and responsiveness.e., quality) show a trade-off relationship. Suppose that the College of Business at Stony Brook University is managing educational services on the frontier curve. If you apply the principle of the trade-off relationship to the operation of business schools, which strategy LEAST contributes to the improvement of the graduation rate of students at the College of Business at Stony Brook University? 1. Increase the size of enrollment (number of students) 2. Increase the number of instructors 3. Provide more students services such asig and counseling 4. Utilize a new technology to improve the quality of teaching 5. Increase the number of TAs to support studentsExplanation / Answer
Q5. The correct answer is Option: 3
Explanation: In order to draw a linear regression in excel spreadsheet, Trendline could be prepared using the data points. This trendline will give the Linear regression equation and co efficient of corerelation i.e R2 . Option 1 is not a command in the excel but it is a process. Options 4 & option 5 are also not able to give the linear regression output.
Q6: The correct answer is Option: 3
Explanation: The dynamic pricing strategy,also called congestion pricing, controls the demand without controlling the supply of service. Take for example, in case of Uber, when ever there is a huge demand of cabs, the cab charges are increased, which discourages the people to take cabs. This way the demand is reduced and thus the congestion of system is controlled by matching the demand with supply. The supply remains the same.
Q7: The correct answer is Option: 1
Explanation: If the size of enrollment is increased, the absolute number of graduating students might increase but the rate may or may not increase. This is because, the total population of students over which graduated students are calculated are also increasing.