Question
This is an Excel question be careful otherwise be ready for atleast 50 dislikes if you provide wrong answer... Don't use any AI or Chat
This is an Excel question be careful otherwise be ready for atleast 50 dislikes if you provide wrong answer... Don't use any AI or Chat Gpt
To better understand the month-to- month variation of the business, you want to know if average daily revenue across months is the same. You want to use an appropriate statistical technique to test your hypothesis. From the results of your hypothesis test, what is the p- value?
I've attached a photo of the question itself, as well as what my data looks like. How do I format my PivotChart and what statistical technique do I do and how do I do it? I'm assuming ANOVA? I will thumbs up the correct answer, thank you!
\begin{tabular}{|c|c|c|c|c|c|c|c|c|c|c|c|c|c|} \hline Transaction Da= & Transation Tir- & Orderi & Product: & Category & Brand & Price 7 & Quant: & User & Customer A & Customer Ratir & Reveniv & Cost: & Prof: \\ \hline 4/5/23 & 3:40:44 & 5502 & 44622 & Roller Skates for Men and Women & PAPAISON & $69.99 & 1 & 9E+06 & 73 & 3 & $69.99 & $59.99 & $10.00 \\ \hline 4/5/23 & 4:44:58 & 2710 & 19622 & Youth Bike Helmet & Mongoose & $27.19 & 1 & 9E+06 & 27 & 1 & $27.19 & $21.00 & $6.19 \\ \hline 4/5/23 & 4:46:13 & 9652 & 47622 & Skateboard & Wiisham & $41.99 & 1 & 2E+06 & 69 & 3 & $41.99 & $33.00 & $8.99 \\ \hline 4/5/23 & 5:22:47 & 179 & 33622 & Outdoor Rock Climbing Rope & Aoneky & $16.99 & 1 & 1E+06 & 80 & 1 & $16.99 & $15.00 & $1.99 \\ \hline 4/5/23 & 5:24:22 & 3684 & 97622 & Motocross Helmet & GLX & $70.80 & 1 & 9E+06 & 73 & 5 & $70.80 & $62.00 & $8.80 \\ \hline 4/5/23 & 5:26:40 & 8980 & 98324 & Trace Folding Scooter & Mongoose & $94.99 & 1 & 2E+06 & 77 & 3 & $94.99 & $79.90 & $15.09 \\ \hline 4/5/23 & 5:30:43 & 596 & 22831 & Kitesurf Trainer Kit with Bar & Flexifoil & $269.97 & 1 & 5E+06 & 74 & 3 & $269.97 & $284.10 & $14.13 \\ \hline 4/5/23 & 5:30:43 & 596 & 15633 & Dolomite Mens Fat Tire Bike & Mongoose & $470.58 & 1 & 4E+06 & 54 & 3 & $470.58 & $453.79 & $16.79 \\ \hline 4/5/23 & 5:30:43 & 596 & 25622 & Apparel Glove & Adidas & $246.95 & 1 & 7E+06 & 79 & 3 & $246.95 & $201.00 & $45.95 \\ \hline 4/5/23 & 5:35:13 & 164 & 22822 & Kitesurf Trainer Kit with Bar & Flexifoil & $269.97 & 1 & 530506 & 50 & 5 & $269.97 & $284.10 & $14.13 \\ \hline 4/5/23 & 5:38:23 & 2283 & 15622 & Knee, Elbow and Wrist Pads for Roller Skating & Skatewiz & $37.99 & 1 & 3E+06 & 70 & 3 & $37.99 & $32.00 & $5.99 \\ \hline 4/7/23 & 4:55:42 & 2696 & 15611 & Neoprene Diving Suit & Dive \& Sail & $52.99 & 1 & 8E+06 & 58 & 3 & $52.99 & $39.45 & $13.54 \\ \hline 4/7/23 & 4:55:42 & 2696 & 15622 & Argus Fat Tire Bike & Mongoose & $549.99 & 1 & 933716 & 71 & 3 & $549.99 & $489.00 & $60.99 \\ \hline 4/7/23 & 4:56:01 & 6181 & 46622 & Rollerblade X Gear 3 Pak & Rollerblade & $61.21 & 1 & 9E+06 & 74 & 3 & $61.21 & $50.11 & $11.10 \\ \hline 4/7/23 & 4:56:01 & 6181 & 22822 & Mens Classic Roller Skates & Chicago & $60.00 & 1 & 5E+06 & 57 & 3 & $60.00 & $43.00 & $17.00 \\ \hline 4/7/23 & 5:11:36 & 869 & 98324 & Trace Folding Scooter & Mongoose & $94.99 & 1 & 6E+06 & 68 & 3 & $94.99 & $79.90 & $15.09 \\ \hline 4/7/23 & 5:12:49 & 8437 & 22830 & Kitesurf Trainer Kit with Bar & Flexifoil & $269.97 & 1 & 5E+06 & 65 & 3 & $269.97 & $284.10 & $14.13 \\ \hline 4/7/23 & 5:12:49 & 8437 & 97622 & Motocross Helmet & GLX & $70.80 & 1 & 4E+06 & 21 & 3 & $70.80 & $62.00 & $8.80 \\ \hline 4/8/23 & 4:23:02 & 9254 & 23823 & Diving Mask & Aqualung & $129.00 & 1 & 2E+06 & 44 & 3 & $129.00 & $124.00 & $5.00 \\ \hline 4/8/23 & 5:07:13 & 9874 & 22831 & Outdoor Rock Climbing Rope & x Xben & $17.99 & 1 & 8E+06 & 68 & 3 & $17.99 & $21.00 & $3.01 \\ \hline 4/8/23 & 5:10:26 & 1075 & 96622 & Motocross Goggles & Fox Racing & $29.95 & 1 & 7E+06 & 40 & 3 & $29.95 & $20.00 & $9.95 \\ \hline 4/8/23 & 5:15:01 & 1336 & 46622 & Rollerblade X Gear 3 Pak & Rollerblade & $61.21 & 1 & 7E+06 & 32 & 3 & $61.21 & $50.11 & $11.10 \\ \hline 4/8/23 & 5:21:50 & 2861 & 35622 & Apparel Glove & Hestra & $154.95 & 1 & 6E+06 & 59 & 3 & $154.95 & $123.00 & $31.95 \\ \hline 4/8/23 & 5:30:23 & 9316 & 15622 & All in one Skate Tools Multi functional skateboard T Tool & Zeato & $8.98 & 1 & 5E+06 & 23 & 3 & $8.98 & $6.35 & $2.63 \\ \hline 4/8/23 & 9:04:47 & 3096 & 98622 & Motocross Helmet & Fox Racing & $129.95 & 1 & 7E+06 & 50 & 3 & $129.95 & $120.00 & $9.95 \\ \hline 4/8/23 & 10:53:56 & 7326 & 15699 & Mountain Bike & Schwinn & $439.00 & 1 & 3E+06 & 26 & 3 & $439.00 & $428.00 & $11.00 \\ \hline 4/9/23 & 14:12:22 & 6986 & 33622 & Outdoor Rock Climbing Rope & Aoneky & $16.99 & 1 & 4E+06 & 44 & 5 & $16.99 & $15.00 & $1.99 \\ \hline 4/12/23 & 6:37:49 & 3462 & 15622 & Climbing Carabiners & Favofit & $19.99 & 1 & 2E+06 & 49 & 4 & $19.99 & $23.00 & $3.01 \\ \hline 4/12/23 & 6:40:42 & 1176 & 15688 & Mountain Bike & Mongoose & $249.99 & 1 & 8E+06 & 58 & 5 & $249.99 & $232.00 & $17.99 \\ \hline 4/12/23 & 6:59:10 & 8287 & 15688 & Mountain Bike & Mongoose & $249.99 & 1 & 8E+06 & 51 & 5 & $249.99 & $232.00 & $17.99 \\ \hline 4/12/23 & 7:00:14 & 3926 & 33622 & Outdoor Rock Climbing Rope & Aoneky & $16.99 & 1 & 4E+06 & 45 & 4 & $16.99 & $15.00 & $1.99 \\ \hline 4/12/23 & 7:13:20 & 2904 & 22831 & Bungee Resistance Band & Dasking & $121.09 & 1 & 9E+06 & 52 & 4 & $121.09 & $112.00 & $9.09 \\ \hline 4/12/23 & 7:14:13 & 92 & 47622 & Skateboard & Meepo Electric & $425.00 & 1 & 2E+06 & 68 & 3 & $425.00 & $420.00 & $5.00 \\ \hline 4/12/23 & 7:14:13 & 92 & 19922 & Freestyle Stunt Scooter & Mongoose & $89.99 & 1 & 9E+06 & 80 & 3 & $89.99 & $82.00 & $7.99 \\ \hline 4/12/23 & 7:16:20 & 3798 & 15622 & Climbing Carabiners & Favofit & $19.99 & 1 & 9E+06 & 40 & 4 & $19.99 & $23.00 & $3.01 \\ \hline 4/12/23 & 7:22:41 & 5275 & 25622 & Apparel Glove & Adidas & $246.95 & 1 & 47274 & 21 & 5 & $246.95 & $201.00 & $45.95 \\ \hline 4/12/23 & 8:41:04 & 3789 & 46622 & Rollerblade X Gear 3 Pak & Rollerblade & $61.21 & 1 & 3E+06 & 39 & 3 & $61.21 & $50.11 & $11.10 \\ \hline 4/12/23 & 8:42:26 & 8057 & 22831 & Outdoor Rock Climbing Rope & Yomega & $17.99 & 1 & 4E+06 & 35 & 3 & $17.99 & $12.00 & $5.99 \\ \hline 4/12/23 & 8:56:51 & 459 & 47622 & Skateboard & WiiSham & $41.99 & 1 & 9E+06 & 25 & 3 & $41.99 & $33.00 & $8.99 \\ \hline 4/12/23 & 9:00:26 & 4823 & 65622 & Thicken Climbing Harness & Weanas & $19.79 & 1 & 8E+06 & 50 & 3 & $19.79 & $14.00 & $5.79 \\ \hline 4/12/23 & 9:01:39 & 8209 & 15699 & Mountain Bike & Schwinn & $439.00 & 1 & 9E+06 & 18 & 5 & $439.00 & $428.00 & $11.00 \\ \hline 4/12/23 & 9:04:43 21 & 4593 & 25622 & Apparel Glove & Adidas & $246.95 & 1 & 6E+06 & 62 & 3 & $246.95 & $201.00 & $45.95 \\ \hline \end{tabular} (1.9 To better understand the month-to-month variation of the business, you want to know if average daily revenue across months is the same. You want to use an appropriate statistical technique to test your hypothesis. From the results of your hypothesis test, what is the pvalue? - Use the Task 9-10 worksheet as your work area. - Hint-Use a PivotTable to group the transactions by month and then reformat the data to be suitable for the appropriate test. Be careful not to do any of this work inside the hypothesis test area. - Place your hypothesis test beginning in cell E3) - Select your p-value answer from the drop down in cell B3
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started