(Use lottery.xlsx file for this question)A 2012 survey by Business Week found that Massachusetts residents spent an average of $850.70 on the lottery, more than three times the U.S. average. A researcher at a Boston think tank believes that Massachusetts residents spend less than this amount. He surveys 100 Massachusetts residents and asks them about their annual expenditures on the lottery. At the 5% significance level, do the data support the researcher's claim? Show all details of your test to receive the full credit.

[YOUR SOLUTION HERE]

Lottery Cells A1 to A101 in exell Vertical order 790 594 899 1105 1090 1197 413 803 1069 633 712 512 481 654 695 426 736 769 877 777 785 776 1119 833 813 747 1244 1023 1325 719 1182 528 958 1030 1234 833 745 985 774 1002 561 681 546 777 844 856 785 1289 502 703 334 1140 594 719 1002 943 1025 969 576 627 989 915 662 802 876 962 878 668 1227 947 864 1016 1022 723 665 1072 610 538 992 978 1291 1139 1111 873 850 941 845 639 495 1016 939 974 893 645 1098 788 682 686 764 759