Tutorial 02_1_2018_solutions.pdf

There is the complication that different use different

Info icon 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.
Image of page 2

Info icon 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
Image of page 3
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
Image of page 4

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

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

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    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.

    Student Picture

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

  • Left Quote Icon

    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.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    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.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern