Information System

1

Part 1 (based on chapters 1, 2 and 3)

Project grading criteria / Rubric:

This is the first part of the project which requires to use descriptive statistics techniques covered

in chapters 2 and 3. This part is worth 65 points and will be graded based on 2 categories:

calculations and conclusions. You should submit an Excel file with your calculations and Word

file with answers to the questions.

Calculations category measures your ability to construct charts and graphs and calculate

numerical measures. You can earn up to 30 points in the category.

Conclusions category grades your ability to understand data, select appropriate charts and

measures, interpret the results given in form of charts and numerical measures. This category is

worth 35 points. You are expected to write at least 2-3 sentences per question.

Dataset description:

A company wants to analyze performance of an ERP system it has been testing. The company

employs about 1,000 people and all of them will use the system. Before the system introduced to

all employees, opinions of several employees who have tested the system have been collected

and provided in the table. The employees were asked to estimate the cost of ownership of the

system and its key characteristics such as ease of use and reliability. Cost of ownership is

measured as Low, Medium, or High. All other characteristics are measured in a scale from 0 to

100 where 100 is the best.

Please, answer the questions below based on the information provided. If some of required

information is not given to you, you can/should make an assumption.

Question:

The goal of this part of the project is to learn how to use descriptive statistics to summarize

information and draw conclusions. Using the given dataset, answer the following questions:

1. Is it a sample or a population? Why?

2. Is it time series or cross-sectional data? Why?

3. What are elements, variables, and observations in the dataset?

4. Define a type of each variable in the dataset (ordinal, nominal, interval or ratio).

2

5. Choose one qualitative variable from your dataset and construct a chart (anyone

appropriate) to summarize information about the variable. Describe what you see on the

chart (2-3 sentences/points).

6. Choose one quantitative variable from your dataset and construct a chart (anyone

appropriate) to summarize information about the variable. Describe what you see on the

chart (2-3 sentences/points).

7. Choose another variable (variables used in questions 5 and 6 CANNOT be used) from

your dataset and calculate 2 numerical measures to summarize information about the

variable. Discuss the results and why this measures were used? (2-3 sentences/points).

8. Choose any 2 variables (can be previously used) from your dataset and analyze

relationship between variables (use appropriate forms of descriptive statistics; charts,

numerical measures, etc.). Are these variables related? Is the relationship linear? Is the

relationship strong or weak? Explain your answers.