the data st in sheet 2 (on excel) is as follows; In-person: 22, 26, 26, 25, 26, 28, 24, 25. ATM: 25, 23, 26, 26, 29, 27. Online: 28, 32, 27, 33, 29, 28, 33.

SUBMISSION QUESTIONS Each question below is worth 20 marks with a total of 60 marks. Question #1: Transactions performed using Three Different Methods (Sheet2): The dataset shows the number of transactions performed at a bank, using three different methods: In- person, ATM, and online banking Determine if there is any significant difference in the number of transactions of the three different methods. (a] include a textbox with the hypothesis statement (b) Perform the appropriate test using the data analysis tool (c) include a textbox with your conclusion (reference both the critical values and p-values) Question #2: Social Media used by Elders living in Canada's Prairie (Sheet3): The dataset shows the number of ciders using social media platforms in Canada's Prairie Provinces listed during the COVID-19 pandemic. Test the claim that the mean number of elders who use social media is different across the Prairie provinces. Question 3: Profits earned from Plots in $ thousands [Sheet4): Four equally wired similar plots were planted with one kind of crop, but the crops sold from each plot resulted in different amounts of profits in thousands of dollars ($ thousand) for each harvesting period. Determine if the profit earned from each of the four plots are different from each other In terms of there amounts