Assignment
1. Explain the difference between qualitative and quantitative variables. Give an example.
2. Explain the difference between a discrete and continues variable. Give an example.
3. Car dealerships shows two years of monthly sales of cars 2017 and 2018.
a) In two columns enter the numbers of cars sold per month (12 values in each column):
Year 2017: 120 125 134 136 140 138 145 150 142 160 110 XXX
Year 2018: 110 140 144 156 150 147 148 162 154 170 250 YYY
Last number for each year needs to be your age plus 100 for 2017, and your age plus 110 for 2018.
b) Make sure that totalmonthly sales number in 2018is larger than thetotal sales number in 2017. (check the numbers you entered by creating sum for each year!)
c) If you need adjustment do it on the first month of the year. Make a note of it on the bottom of the assignment answers.
d) Find the smallest and highest sales for each year.
e) What is the range of numbers?
f) Compare average monthly sales of cars in 2017 and 2018.
g) Compare standard deviation of two years, which year has more consistent monthly sales (base your answer on comparing two st. deviations).
h) Create a bar chart to show the sales per month for each year separately.
i) Create a line chart to show the sales per month for each year separately.
j) Which month has the largest increase of sales in 2017 (compare the sales of the same month with a year before). Place the individual differences in the new column.Try to sort that column and find the highest value.
k) What is the percent of increasefor the month of highest sales?
l) Create probability distribution of sales for each year. Percentages are not needed.
m) Are distributions similar shape?
n) What is the probability (likelihood of) selling between 100 to 140 cars in each year?(140 included) You can express the numbers in fraction or decimal numbers.
o) Save your file with the name that will be:
QMB2100 W2019 9AM (OR 11AM) Midterm 1 last name first initial, and post in the Black Board under midterm 1 tab.
4. Professor Data gave us a list of grades in QMB2100 in Fall of 2015:
83
92
79
85
84
76
94
86
81
77
79
73
98
99
100
100
88
85
99
100
a) Add one more work sheet in the existing file and enter list of 20 grades in the first column (try to copy and past from the word document!)
b) Using function Histogram in Data Analysis (under Data Banner in MS Office 10 or higher) create distribution of frequencies of grades for Dr. Data's exam. Make bin intervals to be with increase of 5 starting with the grade of 60 onwards to 100. Use options of: Chart output and Cumulative percentage.
c) Calculate the mean, find the median and mode of the list of grades.
d) Calculate the range,
e) Calculate the variance andstandard deviation of the grade.
f) if you think that the grades have normal or close to normal distribution (bell) shape interpret how does the empirical role applies to this data set.
g) Using the Cumulative percentage what would be the 25 percentile of the distribution (which grade value),
h) What would be the 80 percentile?
i) How do median and average (mean) compare in the list of grades distribution.
Format your assignment according to the following formatting requirements:
1. The answer should be typed, double spaced, using Times New Roman font (size 12), with one-inch margins on all sides.
2. The response also include a cover page containing the title of the assignment, the student's name, the course title, and the date. The cover page is not included in the required page length.
3. Also Include a reference page. The Citations and references should follow APA format. The reference page is not included in the required page length.