Show how to solve this problem on excel 2023 using a regression that cannot use non numeric data with screenshots

For 12 straight weeks, you have observed the sales (in number of cases) of canned tomatoes at Mr. D's Supermarket. (See the file Grocery.xlsx.) Each week, you keep track of the following:

(a) Was a promotional notice for canned tomatoes placed in all shopping carts?

(b) Was a coupon for canned tomatoes given to each customer?

(c) Was a price reduction (none, 1, or 2 cents off ) given?

Use this data to determine how the preceding factors influence sales. Predict sales of canned tomatoes during a week in which you use a shopping cart notice, a coupon, and reduce price by 1 cent.