using matlab

load the provided cw$9.$xlsx table using readtable command. The data represents the total tip paid by customer in a restaurant detailed by the customer$($s$)$ gender, number, if he$/$she$/$they are smokers, total bill, day and time.

a$)$ Using grpstats command:

On average, who spend more on the total bill, Male or Female?

On average, who spend more on the total bill, Smoker or non$-$smoker?

On average, on which day the customers spend more on the total bill, from Monday to Sunday?

b$)$ Add another column of data, tip$\_$percent, to the table, which is the percent of tips tip$/$total$\_$bill$)$ paid by the customer. To add one column of data to existing table $T,$ create a table $($say Tnew$)$ using this column of data $($using table command$),$ then set Tnew