Dr. Fred Myer has been appointed the chairperson of the Marketing Department at his university. In reviewing the department's cost records, Dr. Myer has found the following total cost associated with Marketing 101 over the last five terms: Term Fall, last year Winter, last year Summer last year Fall, this year Winter, this year Number of Sections Offered 4 6 2 Total Cost $10,000 $14,000 $7,000 $13,000 $9,500 5 3 Dr. Myer knows that there are some variable costs, such as amounts paid to graduate assistants, associated with this course. He would like to have the variable and fixed costs separated for planning purposes. BMW 3. Using the least squares regression method in Excel, what is the linear equation Dr. Myer would use to predict future costs? (15 points) 4. Based on the linear equation provided with the least squares regression method, what would be the estimated total cost of Marketing 101 in the spring of next year if 4 sections of the course were offered? (5 points)