Get a unique, high-quality and non-plagiarized paper from us today at the most affordable price
Email us : premieredtutorials@gmail.com

Excel Assignment for Semester 1, 2016

DUE DATE: 23rd May 2016

Objective:

When you use Excel it is rather like a trick – you don’t know what is happening behind the answer; therefore we get you to do manual calculations for your tutorial work.  The manual calculations show you why and how your software arrives at a particular value.  In the business world you will not be calculating manually.  You will make use of the computer.  Therefore you need experience in using Excel.  We have chosen Excel (instead of Minitab or SPSS) because students have access to Excel (either in the university’s labs and/or on the home computer).

Information and Instructions to Students

You will work with Excel (using ‘Data Analysis’ and the toolbar functions, ¦x) and copy and paste your output onto a word document.  Whatever version of Excel you are working with you will be able to access ¦x and ‘Data Analysis’. However, some questions may require the use of a later version of Excel. For these questions you will need Excel 2010 as found in the labs. If using Excel 2007 click on F1 and type ‘Load Data Analysis’ in the search box and select ‘Load the Analysis Toolpak’ and follow the directions.  If you are using Excel 2010 go to file – click on options – click on add-ins – highlight ‘Analysis Tookpak’ – click on ‘go’.  Tick the square next to ‘Analysis Tookpak’.  Click ok.  To locate Data Analysis click on Data in the main menu. ¦x and ‘Data Analysis’ are the same for all versions of Excel.

The lab assignment is worth 10% and comprises six questions.  The assignment is a self-directed piece of work.  Help on using Excel is available from Robert Williams or your local lecturer only after you have shown evidence that you have attempted to use Excel.  We cannot check your assignment before you hand it in.  Instructions for using Excel are given in your text.

Submission: You submit your (Word doc) assignment via BlackBoard (see Assessment for the submission link) on the date and time as per the Unit ProgramLate assignments will not be accepted under any circumstances. Please be aware of this and start your assignment early.

The cover page to your assignment should include your name, student ID, unit name, tutorial day and time and the words ‘Assignment Using Excel’. Underline your surname.    Keep a backup copy of your assignment.  You must include a typed copy of the two columns of data (complete with your added student ID numbers).

Failure to comply with this instruction will incur a 1 mark penalty.

Assignment

Travel expenses paid by companies can increase or decrease dramatically when there are changes in the daily rates* for hotel rooms.  The following data shows typical daily rates for hotels in 19 Australian towns during 2011 and 2009.

*The average daily rate (ADR) is a metric widely used in the hospitality industry to indicate the average realised room rental per day.  It is one of the key indicators to measure the operating performance of a hotel.

 Hotel Rate in 2011 Hotel Rate in 2009 123 101 119 98 98 67 67 65 88 82 111 76 95 75 75 73 74 97 112 92 88 87 93 65 82 92 51 64 59 69 71 68 67 76 82 87 93 83

Open an Excel spread sheet (you may use Excel 2003, Excel 2007 or Excel 2010) and enter the data which is shown above.  You will now make your data unique by taking the last 4 digits of your student identification number and putting the first two digits at the end of the ‘2011’ data and the last two digits at the end of the ‘2009’ data. For example:  If the last 4 digits of your student number are  1234  then put 12 under the value ‘93’ in the ‘2011’ column and 34 under the value ‘83’ in the ‘2009’ column.  There will now be a total of 40 hotel rates for 20 Australian towns.

Question 1: 1 mark

1. Use fx to find the modes and variance for the ‘2011’. Write down the name of the function to verify that you used Excel.  For example if you were asked to find the mean you would show the function
2. Show a table that displays all the summary statistics for the ‘’2009’ data and highlight the values for the mean, standard deviation and standard error. What is the standard error?  Calculate the standard error manually to verify Excel’s result.

Question 2: 2 marks

1. Display a histogram for ‘2009’ using class widths of 5. Describe the shape of the distribution in terms of skewness and kurtosis.   What are the values for the skew and for the kurtosis?
2. Display an ogive* for ‘2009’ and estimate the proportion of hotel rates that exceed \$80 per day.

* When copying your Excel output to ‘word’ include the ‘bin-frequency-

cumulative % table.

Question 3: 1 mark

We wish to randomly select ten hotels.  Which Excel technique will you use?  Randomly sample the ten hotels.

Question 4: 1 mark

A survey undertaken in May 2011 showed three company executives stayed at the Meriton Hotel, four at the Hilton, two at the Paramount, four at the Abbey, five at the Esplanade and two at the Oaks.  Show two different ways of displaying this information to best advantage (neither of these displays must be a frequency distribution table).

Question 5: 3 marks

1. Hotel rates are normally distributed with a mean of \$98 and a standard deviation of \$15. What is the probability that the rate exceeds \$105?  Use an appropriate Excel function (¦x) to determine the probability.  Write down the formula shown in the formula bar.

1. The commission rate commercial airlines pay travel agents has been declining for several years. If 90% of travel agents charge customers fees when purchasing an airline ticket find the probability that in a randomly selected sample of 100 travel agencies 96 or more charge ticket fees.   Write down the formula shown in the formula bar.

1. Statistics have been maintained for mishandled bags per 1,000 airline passengers. In 2009 an airline had 3.21 mishandled bags per 1,000 passengers.  What is the probability that in the next 1,000 passengers the airline will have at least one mishandled bag?   Use an appropriate Excel function (¦x) to determine the probability.  Write down the formula shown in the formula bar.

Question 6: 2 marks

Can we conclude at the 10% significance level that there is evidence of a difference in the mean daily hotel rate in 2011 and 2009?   Highlight the relevant critical value or p-value and the test statistic to aid you in interpreting the data.

Place your order now for a similar paper and have exceptional work written by our team of experts to guarantee you A Results

Why Choose US

6+ years experience on custom writing
80% Return Client
Urgent 2 Hrs Delivery
Unlimited Free Revisions

#### Looking for a similar assignment. Place your order for a similar paper now and have excellent work written by our team of professionals to ensure you acquire the best grades.

If you find it difficult to balance your work and your studies because you are overwhelmed by other responsibilities, you have come to the right place . With the help of our dependable and simple-to-use essay and research writing service, students are able to focus on work or non-academic-related duties that they are required to carry out and complete all their school work on time .

We assist students who are struggling with their academic endeavors by allowing them to obtain essay assistance from  professional essay writers. We are never late for a deadline. When you ask our writer to write your paper, the assignment can be completed in as little as 12 hours or as long as 2 weeks. The order’s deadline is entirely up to you.

Place an order of your assignment if you are in urgent need of assistance because your essay is due in a few hours/days or you do not know how to complete your professor’s academic assignment. We are here to assist you. You are guaranteed of high grades through our services.

#### How to Place an Order

When you want Premiered Tutorials to do your homework for you, you send the assignment details such as the instructions, due date/deadline, number of pages and college level to the customer support agent online on live chat,  fill in the assignment details at place an order or send the information to our email address premieredtutorials@gmail.com and a customer support agent will respond to you immediately.

Premiered Tutorials has competent writers to handle any of your assignments. Once you place your order, we choose for you the best and competent writer for your assignment based on each writer’s competence in handling a subject.

When the homework is completed, we have a quality assurance team that proofreads the assignment to ensure it meets the required rubric instructions from your professor.

After thorough review of your assignment, we send the paper to the client. In case you need any changes at this point, you can let us know so that we can handle it for you at no extra charge.

#### Why Premiered Tutorials?

If you need professional online homework help at a cheap price from professional and thoroughly vetted online homework helpers, reach out to the best homework help website, Premiered Tutorials.

Whether you are in high school, undergraduate, masters or PhD level, we have the best academic writers to assist you with your homework. We thoroughly vet all our online homework helpers to ensure they are competent to handle our clients’ tasks. Some of the requirements we have is ensuring that they are English Native speakers, have all attended colleges and had high grades in their undergraduate, Masters and PhD classes and have worked as academic writers and delivered high results.

We are a reliable and best essay writing website in the market. Our assignment help services or rather what our clients ask us to do for them include take my online class for me, order an essay cheap, pay someone to write my essay, help with my assignments, history homework help, college homework help, essay writing help online, answers for your homework, pay someone to do my homework for me, homework answers math, pay someone to take my proctored exams and nursing homework assignment help online. As the best website for homework answers, our homework doers also offer cheap essay writing services, online assignment help for all classes

• Law/ Criminal Law
• Nursing
• Information Technology
• Psychology
• Statistics
• Sociology
• History
• Communication
• Culture and Society
• Biology
• Astronomy
• Engineering

The courses indicated above are just but a small group of the types of classes Premiered Tutorials handles.

We have competent homework writers that can handle all academic disciplines regardless of the level of education of our clients.

When we do your homework for you, we write it from scratch to ensure you receive a unique paper. It also ensures that every homework we do for you is free from plagiarism and will help the client to get the highest grades in his or her classes. Any client who manages to consistently use our homework help services is guaranteed of always having the best grades and being one of the top students in the class because we always deliver the best quality for any homework we do for you.

When we complete working on your homework, we deliver the paper to you on time as we are well aware that the work we handle, is time sensitive. Timely deliveries of assignments help our clients get the highest grades because missed deadlines on assignments can result to deductions of marks for late submissions. Therefore, you will always be assured of quality online homework help through Premiered Tutorials whenever you ask us to do your homework for you.

#### Why we should write your Paper

1. Money Return guarantee
2. 0% Plagiarism Rate
3. Guaranteed Privacy
4. Written from scratch by highly qualified writers
5. Communication at Any Time (24/7)
6. Flexible Pricing and Great Discount Programs
7. Timely Deliveries
8. Free Amendments

#### Statistics about Us

130 New Projects
235 Projects in Progress
315 Inquiries
420 Repeat clients

© 2021 Premiered Tutorials
All rights reserved. We provide online custom written papers, such as term papers, research papers, thesis papers, essays, dissertations and other custom writing services.

All papers inclusive of research material are strictly intended to be used for research and study purposes only. Premiered Tutorials does not support or condone plagiarism in any form. These custom papers should be used with proper reference.

error: Content is protected !!