1 answer

QUESTION THREE The weekly Hotel bill (HB) per traveller for COVID-19 mandatory quarantine accommodation and centres...

Question:

QUESTION THREE The weekly Hotel bill (HB) per traveller for COVID-19 mandatory quarantine accommodation and centres are in hi

QUESTION THREE The weekly Hotel bill (HB) per traveller for COVID-19 mandatory quarantine accommodation and centres are in hi

** and *** indicate significance levels of 0.10, 0.05, 0.01 respectively Required: Use the information above and the results

Table 1: Correlation Analysis of Variables HB AA AB AC AD AE AF AG AH HB AA .009 AB .351 -.069 1 AC - 411.036 .249 1 AD .3

Table 2: Regression Result on Hotel Bill (HB) Variables AA AB AC AD AE AF AG AH HB Coefficient 0.248 1.936 -1.696 2.629 -8.09

QUESTION THREE The weekly Hotel bill (HB) per traveller for COVID-19 mandatory quarantine accommodation and centres are in high demand in Accra due to the limited accommodation facilities for these persons. Government may withdraw from taking care of the costs as expert say that the COVID- 19 has come to stay with us similar to other diseases. For this reason, it has become imperative for travellers to carefully plan for their accommodation. Information has been gathered to help travellers predict hotel bill based on the following elements: number of people in a hotel (AA) number of rooms in a hotel (AB), Hotel age (AC), number of beds in a room (AD), Internet connection (AE), Availability of washroom in a room (AF), Distance from hotel to airport (AG) and Traveller type (AH). The study primarily used primary data obtained from 84 travellers sampled for the process. Data was analysed using the correlation and regression analysis. The results from the correlation and regressions analysis are displayed in tables 1 and 2 respectively.
We were unable to transcribe this image
** and *** indicate significance levels of 0.10, 0.05, 0.01 respectively Required: Use the information above and the results from tables 1 and 2 to answer the following questions. a) Identify the dependent and independent variables of the study. (2 marks) b) Explain why each of the variables you have identified in 3a above is either an independent or dependent variable. (4 marks) c) To what extent does this study reflect a case study? (2 marks) d) Identify the variables that were significant at 1% significant level. e) From the correlation matrix which variable had the weakest correlation? (2 marks) 1) Was the model fit to achieve the objective of the study? g) How would you interpret the adjusted R-square and R-square values of 31.4 and 38 respectively. (4 marks) h) Which statistical technique will you advice the travellers to use to achieve the research objective. (4 marks) i) Propose a suitable title for the study. (2 marks) j) Formulate the null and alternate hypotheses for this study. (4 marks) k) Was your hypothesis directional or non-directional? Justify. (2 marks) 1) Draw a conclusion for the study based on your null and alternate hypotheses? (2 marks) m) What basis did you draw the conclusion in (1) above? (2 marks)
Table 1: Correlation Analysis of Variables HB AA AB AC AD AE AF AG AH HB AA .009 AB .351" -.069 1 AC - 411".036 .249" 1 AD .398" .062 492" 634" 1 AE -374" .052 533" 566" 611" 1 AF .021 .035 - 1897.141 -161 - 293" 1 AG .159 .047 .078 .241' 559" 329" -.154 1 AH -.071 -643" -.004 - 185.083 - 203 2009 .140 1 "Correlation is significant at the 0.05 level "Correlation is significant at the 0.01 level
Table 2: Regression Result on Hotel Bill (HB) Variables AA AB AC AD AE AF AG AH HB Coefficient 0.248 1.936 -1.696 2.629 -8.09** 23.27*** 1.42* 3.056 84 38 Prob. 0.889 0.787 0.088 0.081 0.046 0.000 0.086 0.338 N R-Squared

Answers

a) Dependent variable: Hotal Bill (HB)

Following are the independent variables

No. of people in hotel: AA,

No. of rooms in hotel: AB

Hotel age: AC,

No. of beds in a hotel room:AD,

Internet connection: AE

Availablility of washroom in a room: AF

Distance from hotel to airport:  AG

Traveller type: AH

b) Hotel bill is to be predicted by the traveller hence it is a dependent variable.

The other variables are the predictor variables or the independent variables that will help determine the Hotel Bill.

c) This may not be a case study to the complete extent since it misses the final report of the analysis.

d) Availability of washroom in a room: AF is the only variable which is significant at 1% level.

e) From the correlation table, Number of people in hotel (AA) had the weakest correlation with HB.

f) The model has a R2 value of  38, which means the independent variables explain only 38% of the variance, which does not seem to be very good.

g) Adjusted R2 is 31.4 and R2 is 38. The not so high difference in the 2 values imply that most of the independent variables are significant in the model .

.

Similar Solved Questions

1 answer
Enter Your Name Here BASE DATA: Foundation Data for Solving questions 1, 2 and 3: Budgeted...
Enter Your Name Here BASE DATA: Foundation Data for Solving questions 1, 2 and 3: Budgeted Direct Materials Cost Per UNIT 15.00 10.00 Budgeted Direct Manufacturing Labor Per UNIT Budgeted Manufacturing Overhead Per UNIT 5.00 IN ADDITION TO ABOVE USE THE FOLLOWING: This is Next Year's Budgeted Da...
1 answer
Problem 2: _This platform can be considered a uniform plank of mass 200. kg and length...
Problem 2: _This platform can be considered a uniform plank of mass 200. kg and length 3.00 m. A 50.0 kg mass is 75.0 cm from one end. It rests on supports on either side. How much force does each support exert?...
1 answer
Two corners of a triangle have angles of # ( pi )/ 3 # and # ( pi ) / 4 #. If one side of the triangle has a length of # 1 #, what is the longest possible perimeter of the triangle?
Two corners of a triangle have angles of # ( pi )/ 3 # and # ( pi ) / 4 #. If one side of the triangle has a length of # 1 #, what is the longest possible perimeter of the triangle?...
1 answer
You are given a cylinder, a ring and a sphere with the same mass and radii...
You are given a cylinder, a ring and a sphere with the same mass and radii respectively. Which has the least moment of inertia?...
1 answer
8.) (16points) If v = x2 sin y + r exy, where x-s+ 2tp. r = 4pt, and y-In(pts). A.) Draw a tree diagram for this fu...
8.) (16points) If v = x2 sin y + r exy, where x-s+ 2tp. r = 4pt, and y-In(pts). A.) Draw a tree diagram for this function. Label the intermediate, the independent, and the dependent variables. av B.) Find a C.) Find ov when p = 1,t=2,s=2 8.) (16points) If v = x2 sin y + r exy, where x-s+ 2tp. r = 4...
1 answer
1) Find two examples of other polymers that can be degraded into monomers). Provide chemical reactions....
1) Find two examples of other polymers that can be degraded into monomers). Provide chemical reactions. 2) Write any three organic reactions that the product (terephthalic acid) can engage in....
1 answer
How do you find the roots of #x^3-8x^2-200=0#?
How do you find the roots of #x^3-8x^2-200=0#?...
1 answer
8. Below is a schematic of the glycolytic pathway. HOW would you identify WHICH reaction(s) was...
8. Below is a schematic of the glycolytic pathway. HOW would you identify WHICH reaction(s) was or was not RATE Limiting? WHAT DATA do you NEED to KNOW ?????...
1 answer
Yellow Tartan is a levered firm with the following financial statements: Balance Sheet Income Statement Total...
Yellow Tartan is a levered firm with the following financial statements: Balance Sheet Income Statement Total assets $ 1,000,000 Sales $ 3,500,000 Variable costs -$ 1,200,000 Bonds (coupon rate of 8%) $200,000 Fixed costs -$ 1,000,000 Bonds (coupon rate of 6%) $ 300,000 Depreciation -$ 600,000 Commo...
1 answer
EBook Show Me How Calculator Print Item Stock Investment Transactions On September 12, 3,600 shares of...
eBook Show Me How Calculator Print Item Stock Investment Transactions On September 12, 3,600 shares of Aspen Company are acquired at a price of $61.00 per share plus a $180 brokerage commission on October 15, a 31.10-pershare dividend was received on the Aspen Company stock. On November 10, 1,440.00...
1 answer
Cesium flouride is a highly ionic compound. Calculate the strength of the Cs+ - F- bond....
Cesium flouride is a highly ionic compound. Calculate the strength of the Cs+ - F- bond. Assume repulsive energy is 10% of attractive energy at the equilibrium seperation....
1 answer
Studying for my final, help 19) [5 pts) A photon with an energy of E, =...
studying for my final, help 19) [5 pts) A photon with an energy of E, = 2.090 GeV creates a proton-antiproton pair in which the proton has a kinetic energy of 95.0 MeV. What is the kinetic energy of the antiproton? (m,c2 = 938.3 MeV a. 50.8 MeV b. 84.2 MeV c. 118.4 MeV d. 60.2 eV e. 231.4 MeV...
1 answer
What is the pathophysiology for acute kidney injury most likely related to diarrhea, nausea/vomiting post op...
What is the pathophysiology for acute kidney injury most likely related to diarrhea, nausea/vomiting post op sleeve gastrectomy and priority nursing diagnosis?...
1 answer
Don't answer this question, It was a manipulation error. That is the correct question I want answer for (5) For a random sample of size n from a Uniform (0, 5+ ple of size n from a Uniform...
don't answer this question, It was a manipulation error. That is the correct question I want answer for (5) For a random sample of size n from a Uniform (0, 5+ ple of size n from a Uniform ( θ, 5+8) population, write estimators of o (both of which f which use the entire sample). Call t...
1 answer
How do you find the slope given #4x+5y= -2#?
How do you find the slope given #4x+5y= -2#?...
1 answer
Questions 1. What type of pathogen is Candide glabrata? C. Viral a. Bacterial d. Parasitic b....
Questions 1. What type of pathogen is Candide glabrata? C. Viral a. Bacterial d. Parasitic b. Fungal What area(s) of the body are commonly colonized by C. glabrata? 3. What type of pathogen is Burkholderia cepacia? c. Viral a. Bacterial b. Fungal d. Parasitic 4. What is usual source/habitat of B. ce...
1 answer
On December 31, 2017, Green Company rendered services to End Corporation at an agreed price of...
On December 31, 2017, Green Company rendered services to End Corporation at an agreed price of $91,844.10, accepting $36,000 down and agreeing installments of $18,000 promissory note rece ivable each December 31. Under the circums tances , the note is considered to have an appropriate imputed rate o...