Hello, dear friend, you can consult us at any time if you have any questions, add WeChat: THEend8_
MGEB11 Excel Lab: Sample Questions
This is the link to the lab evaluations. I would appreciate it if you could fill this out. Thanks!
1. Scores for Topics in Macroeconomics are normally distributed with a mean of 70 and a
standard deviation of 10. Find the first quartile of the marks for the exam.
a. 76.7
b. 63.3
c. 65.2
d. 35.2
2. The age of crocodiles is normally distributed with a mean of 70 and a standard deviation
of 25. Suppose a crocodile that you know is 28 years old, what is the standardized value
corresponding to this observation?
a. -1.68
b. 1.23
c. 2.01
d. 0.668
3. The weight of certain species of mice follows a t-distribution with 25 degrees of freedom.
What is the 85th percentile of mice's weight?
a. 2.2140
b. 0.7800
c. 1.0584
d. 1.7892
4. You are provided with a data-set containing the annual inflation rate of U.S and China
since 1987. Which of the following charts is best for visualizing the inflation rate over
time, for both economies?
a. Line chart
b. Histogram
c. Pie Chart
d. Scatter Plot
Please refer to the test data. Below is an explanation of each column.
1) University GPA: Sum of the first three years (ranging from 0 to 12)
2) High School GPA from high school (range: 0 to 12)
3) SAT score (range: 400 to 1600)
4) Extracurricular Activity: The average number of hours per week spent in extracurricular
activities in the last year of high school.
5. Which of the following variables has the strongest correlation with University GPA?
a. High School GPA
b. SAT score
c. Extracurriculars
6. Create a histogram for SAT score. Select the correct one.
To answer Q7 to Q10, a Pivot Table is recommended
7. What is the average number of hours per week spent in extracurricular activities by
Maplewood High School?
a. 4.1 hours
b. 5.1 hours
c. 3.2 hours
d. 6 hours
8. Plot a chart that shows the number of students per high school
9. What is the highest SAT scored by a UMC High School student?
a. 1344
b. 1450
c. 1385
d. 1337
10. Which students have had the best University GPA on average?
a. FH International High School students
b. Maplewood High School students
c. UMC High School students
d. West Hill Collegiate Institute students
e. Woburn Collegiate Institute students
Formula Sheet
Distributions Inverse Distributions
Distribution
Name Function Name Function
Normal
Distribution
=NORM.DIST(x, mean,
stdev, cumulative)
Normal CDF
Inverse
=NORM.INV(probability,
mean, stddev)
Standard
Normal
Distribution
=NORM.S.DIST(z_score,
cumulative)
Standard
Normal CDF
Inverse
=NORM.S.INV(probability)
Student t-
Distribution
=T.DIST(t_value,
deg_freedom,
cumilative)
t-
Distribution
Inverse
=T.INV(probability, df)
Extra
NAME FUNCTION
Standardizing Z
=STANDARDIZE(x,
mean, standard_dev)