I need help answering the below questions for an assignment. This assignment uses the data listed below. Please let me know if you can help.

22.8

23.8

30.7

27.2

26.8

25.9

28.6

30.7

27.2

25.0

24.9

26.6

31.2

30.3

28.2

27.7

30.3

30.1

24.2

22.6

22.4

24.0

22.8

24.1

23.6

29.8

29.5

31.3

26.7

27.9

28.3

31.6

26.8

31.1

29.9

31.7

23.0

30.0

24.9

27.1

29.4

31.8

23.5

27.0

24.0

25.9

30.5

24.8

31.9

24.9

This assignment is to be done individually, not in groups. In reporting the values requested below, please use an a level of .05 and be sure that your value is accurate to at least three places to the right of the decimal point. This Assignment is drawn from a true lawsuit, but the data have been fabricated for the purposes of this course. A lawsuit against Hyundai in Sacramento, California, Superior Court is seeking class-action status that alleges that the automaker Kia made false advertising claims for its popular Soul model, among others. As the litigation manager for Kia, you wish to determine whether the claim has any merit. 0f principal interest is whether Kia's stated claim (34 mpg for highway) for the Kia Soul was too high. (In determining the Ho and Ha, please read the preceding sentence carefully.) A random sample of 50 new Kia Souls were selected for study, and the gas mileage was assessed: these data are contained in the "Soultxt" le. Based on these data, and using only Excel for the analysis, please complete the following template: 1. Hypotheses | Symbolic: In words: Ho: Ha: 2. Procedure: 3. Assumptions: 4. Assumption tenability: 5. Results: n Std. Error Test Critical Accept Ho HA Test Value d.f. Value of t HA? Single Sample t-test Text accompanying the Results: 6. Implications