Please complete answering ALL questions in MS Excel. Note: I will be looking for calculations in the respective cells. 1. Below is the table showing rate of bags sold per day and the highest-prices bag sold that day for a one-week period. The rate of bags sold per day (X) and the price of bags (Y). Bags sold in % (X) Price (Y) 15 27 $55 $40 S88 25 S53 S47 S48 10 13 9 18 S40 Using the data in the table, Calculate: a) the mean for X b) the variance of X c) the standard deviation for Y 2. Using the data in the table below, calculate: Observation A1 A2 A3 A4 AS A6 A7 a) Mean for Items b) Variance c) Standard Deviation Item Cost $1345 S4364 S1768 $2287 S4332 S2984 $3326 Please complete answering ALL questions in MS Excel. Note: I will be looking for calculations in the respective cells. 1. Below is the table showing rate of bags sold per day and the highest-prices bag sold that day for a one-week period. The rate of bags sold per day (X) and the price of bags (Y). Bags sold in % (X) Price (Y) 15 27 $55 $40 S88 25 S53 S47 S48 10 13 9 18 S40 Using the data in the table, Calculate: a) the mean for X b) the variance of X c) the standard deviation for Y 2. Using the data in the table below, calculate: Observation A1 A2 A3 A4 AS A6 A7 a) Mean for Items b) Variance c) Standard Deviation Item Cost $1345 S4364 S1768 $2287 S4332 S2984 $3326 3. Replicate this table in MS Excel, Macy's Garden Supplies Local Garden Program Date Number of Items Quantity in Stock 2.79 Item Cost Each Type Category Quantity in Stock Reorder Supplier Rosemary $ 5.72 Earth Cover Vegetation 23 Shovel $24.99 Handheld Equipment 12 Petunias $ 2.98 Plant Flower 45 Dill $ Earth Cover Vectation 92 Cucumbers $ 1.75 Plant Vectable 10 Peas $ 1.20 Plant Vegetable 18 Potatoes s 2.75 Plant Vegetable 8 Rhubarb $ 5.29 Plant Vegetation 48 Marigolds $ 4.56 Plant Flower 52 Begonias S 9.15 Plant Flower 78 Irises S 35.79 Plant Flower Sage s 4.89 Earth Cover Vegetation 116 Clipper $ 13.79 Handheld Equipment 11 Squash $ 2.75 Plant Vegetable 18 Tomatoes 5.50 Plant Vegetable 110 Hand Shears $14.95 Handheld Equipment 7 Mulch S 12.74 Soil Drainage 89 Fork $ 22.25 Handheld Equipment 14 Forget-Me-Nots S 3.59 Plant Flower 120 Bulb Planter $ 4.79 Handheld Equipment 12 Garden Cart S 29.39 Handheld Equipment 9 Composter $ 58.89 Barrel Equipment Clay Pot 12" $ 27.99 Container Equipment 76 Use MS Excel functions compute values for the following shaded cells. a) Date (Current date) b) Number of Items c) Quantity in Stock d) Reorder Items - Insert text "Reorder" if the quantity in stock per item is under 15. If the quantity in stock of an item is -15 then insert the text "Level Okay". c) Supplier. Insert the text "Check for new supplier" if the cost of an item is greater than $25. Leave other supplier cells blank