$($PLEASE SHOW HOW YOU MAKE THE CHARTS ON EXCEl$<$ THIS QUESTION HAS BEEN ANSWERED BEFORE BUT THEY DIDNT SHOW HOW TO MAKE THE GRAPHS$)$How does consumer response to advertising vary on different days of the week and at different times of the day?

Create a chart with the conversion rates for the control group and the exposed group as a function of the day of week when they were shown the most impressions.

Create the same chart for hours within a day $($excluding the period between midnight and $8$ am$).$

What days$/$hours is advertising most$/$least effective?