A travel blogger is interested in investigating how much total money (in $) do solo travellers usually spend during their 1-week holiday or vacation (including airfare/ car gas consumption,...

A travel blogger is interested in investigating how much total money (in $) do solo travellers usually spend during their 1-week holiday or vacation (including airfare/ car gas consumption, accommodation, food, package tour, etc.) within Australia. A total of 50 randomly selected participants were surveyed regarding their estimated total expenses in their last holiday getaway

Question 1 Travel Expenses 1155 750 950 750 2200 1800 1270 975 850 650 1075 2200 1540 890 1205 850 890 900 1350 800 970 1390 860 950 700 1450 1300 2350 1850 780 1850 2000 1750 1300 900 1250 1350 950 2500 2150 1145 1120 1250 1050 1200 2150 2300 1920 1500 1200 Question 2 StudentsBefore ScoreAfter Score 14540 23230 34239 43443 53240 64340 73233 83541 93240 103845 114040 124142 133244 144444 154343 Question 3 Number of optional homeworksFinal grade 5060 4565 3555 3160 3058 5973 6175 6374 4570 5268 2045 5872 5560 3850 4062 6458 6870 7075 6578 7580 7090 8095 4265 1545 These data comprise of the following variables: Question 1 DATA worksheet 1st column (Travel expenses) Total money ($) spent by 50 Solo travellers Question 2 DATA worksheet 1st column (Students) Students who participated in the study 2nd column (Before) Scores before the course 3rd column (After) Scores after the course Question 3 DATA worksheet 1st column:Number of Number of optional homework done by the students Optional homework 2nd column Final grade Final grade of the students Data source: Data produced using an Excel random number generator. Question 1(6 marks)Marks A travel blogger is interested in investigating how much total money (in $) do solo travellers usually spend during their 1-week holiday or vacation (including airfare/ car gas consumption, accommodation, food, package tour, etc.) within Australia. A total of 50 randomly selected participants were surveyed regarding their estimated total expenses in their last holiday getaway All work for this question must be done using the worksheet named Question 1 Data. This worksheet can be found in the data file Data Set& 2021.1.xlsx. (a) Using Excel, obtain a Descriptive Statistics output of the “Travel Expenses” column in your data file. (MeanMedianModeRange and Standard Deviation)* [1] (b) Using Excel, construct a histogram, which shows the amount of money spent by the solo travelers in their last holiday getaway. Construct your histogram with 5 classes (bins) by selecting the appropriate class width.(Clearly label the axes.[2] (c) Using the descriptive statistics and the histogram from the above questions, comment on the distribution of the “Travel Expenses” for these 50 participants. In particular, comment on the shape of the distribution.[2] (d) Using appropriate Excel output construct a 95% confidence interval for the population mean of the travel expenses.[1] * Evidence of work in Excel is required Question 2 (8 Marks)(8 marks) All work for this question must be done in the worksheet named Question 2 Data.Marks This worksheet can be found in the data file Data Set& 2021.1.xlsx. An English comprehension test is given to a random sample of 15 UWSCollege foundation students before and after they complete an English support course. The data provided shows the scores before the course and after the course to analyse if the support course improved the scores. (a) Using Excel, obtain an output for the hypothesis test at 5% level of significance.*[3] (b) Using the information in the output, conduct a hypothesis test in the space below. Make sure that you state the null and the alternative hypothesis, the decision rule and the value of the test statistics. Explain your decision and write a conclusion.[5] * Evidence of work in Excel is required Question 3 (6 marks)Marks All work for this question must be done in the worksheet named Question 3 Data. This worksheet can be found in the data file Data Set& 2021.1.xlsx. A Business Statistics instructor at a city college would like to examine the relationship (if any) between the number of optional homework problems students do during the term and their final course grade. He randomly selects 24 students for study and asks them to keep track of the number of these problems completed during the course of the term. Each student’s total is recorded along with his or her final grade. (a) Using Excel, obtain a linear regression output.*[2] (b) Determine the linear regression equation that may be used to predict the final course grade based on the number of optional homework problems done by the students.[1] (c) Interpret the slope of the linear regression line.[1] (d) State and interpret the coefficient of determination.[2] * Evidence of work in Excel is required END OF APPLIED PROJECT WSTC 2021.1 Statistics for Business – Applied Project