Lab 2_Problems & Exercises (3)

.xlsx

School

Curtin University *

*We aren’t endorsed by this school

Course

1000

Subject

Accounting

Date

Jan 9, 2024

Type

xlsx

Pages

24

Uploaded by ChiefGiraffeMaster910

Report
The lab 2 Problems, Textbook Chapter 2, Pages 75-85 Essential problems to be done in class with your Tutor Extension problems to be attempted if you want a challenge. (To unhide any extension activities you might want to explore, for example Right-click tab 2.1 below, Left-click "Unhide", then choose a P&E you want to Hint: These are solutions worksheets that contain the data with formatting, formulas, sometimes a screenshot from the textbook Lab Learning Modules in the ECOM1000 Blackboard Site have the original data files, you should in all cases use the original data and do the problem yourself for the best learning!
Unhide)
Airbnb Samples (Naming data and using the "AVERAGE" function) Sample Room Rates Sample Observations Average Accomodation 1 $159 $162 $125 $75 $329 $170 Accomodation 2 $400 $70 $250 $125 $115 $192 Accomodation 3 $48 $200 $120 $90 $100 $112 Accomodation 4 $65 $89 $190 $50 $220 $123 Accomodation 5 $200 $109 $69 $70 $129 $115 Accomodation 6 $150 $100 $101 $89 $180 $124 Accomodation 7 $170 $175 $120 $199 $190 $171 Accomodation 8 $130 $139 $288 $99 $89 $149 Accomodation 9 $100 $200 $300 $150 $59 $162 Accomodation 10 $115 $150 $120 $470 $225 $216 Accomodation 11 $110 $56 $155 $55 $230 $121 Accomodation 12 $92 $150 $150 $150 $65 $121 Accomodation 13 $149 $144 $320 $105 $114 $166 Accomodation 14 $295 $88 $120 $149 $98 $150 Accomodation 15 $149 $95 $141 $100 $169 $131 Accomodation 16 150 160 170 180 190 170 As for Problem 2.1 define the Row names this time and use a formula to calculate the average of Samples 1-15 in column G Select a row of data to see the range name in the Name box (e.g., B4:F4). Click on a formula in column G to see the range names applied. Th has wit G1 Th on you for Av See an try
Sample Room Rates Sample Observations Accomodation 1 $159 $162 $125 $75 $329 $170 Accomodation 2 $400 $70 $250 $125 $115 $192 Accomodation 3 $48 $200 $120 $90 $100 $112 Accomodation 4 $65 $89 $190 $50 $220 $123 Accomodation 5 $200 $109 $69 $70 $129 $115 Accomodation 6 $150 $100 $101 $89 $180 $124 Accomodation 7 $170 $175 $120 $199 $190 $171 Accomodation 8 $130 $139 $288 $99 $89 $149 Accomodation 9 $100 $200 $300 $150 $59 $162 Accomodation 10 $115 $150 $120 $470 $225 $216 Accomodation 11 $110 $56 $155 $55 $230 $121 Accomodation 12 $92 $150 $150 $150 $65 $121 Accomodation 13 $149 $144 $320 $105 $114 $166 Accomodation 14 $295 $88 $120 $149 $98 $150 Accomodation 15 $149 $95 $141 $100 $169 $131 Accomodation 16 150 160 170 180 190 $170 he average calculation formula s been removed and replace th the answer in cells G4 to 18. he Unit Coordinator has pasted nly the answer values here and u should try to write the rmulas to calculate these verages. e the Solutions worksheet for nswers if you are unsuccessful ying to write the formulas.
Qu. After leaving Curtin University you become an AirBnB Investor and Property M How does the average foom rate for your 15 properties help you make decisio What type of decisions might it help you with? help inform on how to price each room
Manager ons?
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help