1.Using the McDonals.xlsx dataset, create scatter plot that depicts the relationship between Average Frequency and Income. Note that this is the frequency in which a person visits McDonalds per week.

The scatter plot illustrates the relationship between weekly average visits to McDonald’s and income level. Overall, there is a trend of more frequent visits to McDonald’s as income increases, although there is some variation in visit frequency among the mid-range income levels.

2.Using the Dow.xlsx dataset, create a line chart that depicts the average return (y axis) by month (x axis).

The monthly investment returns data from January 1993 to February 1947 fluctuates between positive and negative, signaling varying performance, so careful analysis is required to identify any trends or patterns in the investment’s behavior.