Target versus Walmart: Who had the lowest prices? To addressyour consumer thirst for knowledge you identify 20 items (allbrand-name items) currently on your household shopping list. Youvisit both your Local Target and Walmart, price each item,organize, and then store these data in TargetWalmart. Is thereevidence to support that prices are cheaper at Walmart? (Use a 0.05level of significance)
Please show me how to do this in excel using the data analysistab
| Shopping Item | Target | Walmart |
| 1 | 5.09 | 5.47 |
| 2 | 10.99 | 11.97 |
| 3 | 3.29 | 2.85 |
| 4 | 14.97 | 12.97 |
| 5 | 4.99 | 4.97 |
| 6 | 18.99 | 14.97 |
| 7 | 3.89 | 6.98 |
| 8 | 10.98 | 7.92 |
| 9 | 2.99 | 2.75 |
| 10 | 2.99 | 2.75 |
| 11 | 2.99 | 3.98 |
| 12 | 2.19 | 1.89 |
| 13 | 9.29 | 9.27 |
| 14 | 5.99 | 5.86 |
| 15 | 3.98 | 3.58 |
| 16 | 3.19 | 2.67 |
| 17 | 2.99 | 2.98 |
| 18 | 2.39 | 2.18 |
| 19 | 2.09 | 1.89 |
| 20 | 3.98 | 3.97 |
