This attached template has two worksheets. Use a PivotTable to summarize the data for Problem 1 by putting the Major on the Row label with Count of Major and Average of Monthly Salary as the Values; see the image below for an example.

On the Problem 2 worksheet, insert a scatter chart with x and y on their respective axes (this will be the default anyway). Next, add a trendline and change the line style of the trendline to solid as done in the lecture videos. Finally, choose an option from the drop-down menu in the yellow-shaded cell to indicate what kind of relationship between x and y is evidenced in the scatter chart you created.

Don't forget to save early and often! When both questions are complete, upload your completed template to this folder. As before, you can overwrite your attempt as many times as you like, but only the last attempt will be graded.