Tutorial 02_1_2018_solutions.pdf

# There is the complication that different use different

• Homework Help
• 10

This preview shows pages 2–5. Sign up to view the full content.

There is the complication that different countries/manufacturers use different procedures for determining size. In these cases, shoe size may be only an ordinal variable because there may not be a well-defined, regular unit of measure. Question 2.2 Data collected for the following variables is to be displayed graphically. Which type of graph is most appropriate, bar charts, pie charts or histograms? a. number of passengers in flights 100 flights in sample Bar Chart (Histogram if you group the data) b. type of petrol purchased (super, unleaded, premium) Bar Chart/Pie Chart c. prices of cars sold in Melbourne over a weekend Histogram d. state of residence of a sample of 200 Australians Bar Chart/Pie Chart e. number of cigarettes smoked in a day (a sample of 120 people) Bar Chart (Histogram if you group the data) Question 2.3 One hundred and twenty-one university students were asked to identify their preferred leisure activity. The results are displayed in a bar chart, as shown below.

This preview has intentionally blurred sections. Sign up to view the full version.

ETF1100 Business Statistics SOLUTIONS Tutorial 2 3 a. What percentage of students in total nominated either listening to music or reading as their preferred leisure activity? 27% b. State the least popular leisure activity for these students and quote the percentage. Reading, 11% c. Based on your answer in (b), how many students rated this activity as their preferred leisure activity? 13 students Question 2.4 Recall slide 44 of Lecture 1, problem 2.17, data represents the electricity cost in dollars during the month of July for a random sample of 50 two-bedroom apartments in a New Zealand city. 44 We created a table with class intervals using the Pivot “Group” options. 0 5 10 15 20 25 30 Sport TV Music Movies Reading Other Percentage Preferred Leisure Activity Preferred Leisure Activity of University Students
ETF1100 Business Statistics SOLUTIONS Tutorial 2 4 Based on the information in this table, around what amount does the monthly electricity cost seem to be concentrated? \$140-\$160 For the following tasks, you will need to use Excel: (Here’s a video I found that you might find helpful!) Task 1: Using COUNTIF and bar charts for qualitative data SORTED DATA The trustee of a mining company’s accident compensation plan solicited the employees’ feelings toward a proposed revision in the plan. There are three types of job classifications: (Mine-Workers, Clerical staff and Managers denoted by W, C and M) and two possible decisions, either For (F) or Against (A). The data is available in COUNTIF” worksheet in the file COUNTIF function.xls in the After Interactive Lectures : Tutorial Material section, Week 02 folder on Moodle. Sort the data by the variable “Job classification”. When sorting a number of columns of data by one variable, you must highlight the whole block of data (all required rows and columns) first. If you just highlight the column for the variable you are sorting by, then the values of this variable will be separated from the cases to which they belong. Click on

This preview has intentionally blurred sections. Sign up to view the full version.

This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

### What students are saying

• As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

Kiran Temple University Fox School of Business ‘17, Course Hero Intern

• I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

Dana University of Pennsylvania ‘17, Course Hero Intern

• The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

Jill Tulane University ‘16, Course Hero Intern