COL-110 Spring 2013
Practice Problems 1 for Final Exam
1a) The number 70 is the Bin of which interval?
a) 50-60b) 60-70c) 70-80d) 80-90
b) In which of those intervals the data 80 would be included?
2) CircleALL the formulas that will do exactly the same thing in Excel:
a) =B1+B2b) =Count(B1,B2)c) =Median(B1,B2)
d) =Sum(B1,B2)e) =Total(B1:B2)f) =Average(B1,B2)
3) Explain the differences between the cell references A1, $A$1, A$1 and $A1.
4) Which of the following type of charts can be used if we want to compare the evolution of the unemployment rates between 1995 and 2012 in three countries? (circleALL the good answers, it can be 1 or more):
a. Column chartb. Pie chartc. Bar chartd. Line charte. Histogram
5) For each of the following variable, determine if it is qualitative or quantitative and with which level of measurement:
Variable / Qualitative / Quantitative / Nominal / Ordinal / Interval / RatioQuantity of cream in a tube (in grams)
Size of eggs (A to D, A means bigger)
Color of eggs (brown or white)
Temperature of the room in degree Celsius
6a) Suppose we write in cell B1 the formula =IF(A1>=78," ",A1/2+1) and copy it down column B. Write below the result in column B:
b) Same question this time with the formula =IF(A1<50,"A1/2+1"," "):
7) Fill in the last column with the most appropriate answer.
NUMBER / ROUNDING INSTRUCTION / Enter your answer here127.46352 / rounded to three decimal places is
0.005 / rounded to the nearest hundredth is
159.99 / rounded to the nearest whole number
0.12345 / rounded to 2 decimal places is
8) Suppose the number 7,365.681 is in cell A1 of a spreadsheet. Use an Excel formula (write the formulasand results below) to round this number to the nearest:
a) tenthsb) tensc) hundredthsd) hundreds
Formula / Resulta
b
c
d
9) Write the Excel formula needed to compute: .
10) Using the table below, write the Excel formulas needed to convert:
a) 1032 CHF to AED.b) 1032AED to US Dollars.
11a) Write the following numbers in scientific notation (use 2 decimals):
i) 0.00000026357ii) 1,546,324,567
b) What is the number represented in Excel by: 4.98 E-9 ?
12) The following table shows the labor force (number of workers) for two countries between 2007 and 2010.
a) Which Excel formula has been used in cell C5?
b) Which Excel formula has been used in cell D7?
c) Interpret precisely the numbers in cell C6 and cell G6.
C6:
G6:
d) In which of the two countries and for which year the number of workers increased the most? Explain.
e) In which of the two countries and for which year the labor force increased the most significantly? Explain.
13) CircleALL the correct statements related to the table:
a) The infant mortality rate in Bangladesh decreased by -14% between 2007 and 2010.
b) The infant mortality rate in Bangladesh decreased between 2007 and 2010.
c) The infant mortality rate in Bangladesh was higher in 2007 than in 2010.
d) The infant mortality rate in Bangladesh remained stable between 2007 and 2010.
e) The infant mortality rate in Bangladesh decreased by 14% between 2007 and 2010.
14) A College has students in years 1 to 4. The table below gives the number of students for each year:
Write an Excel formula that will give the percentage of first year students in this college.
15) Suppose the number of traffic fines for last year for 12 people are:
2013255606620
a) What is the mode?
b) What is the median?
c) What is the average?
d) Is the average or the median the best measure of center in this situation? Explain.
e) Is the fines distribution symmetric or not? Explain.
f) If we enter the data in Excel and use the Excel functions for central tendency, what would be the results for each?
16) The table below gives the number of Tuberculosis cases per 100,000 habitants in different countries in 2010.
Note: this is only a copy of a part of the table. The actual one contains much more rows. Measures in column Q are for the complete table.
a) Determine for each of the following frequency tables, if it COULD be a correct representation of the data. Explain why.
b) What would be the title, thex-axisand they-axis labels for the histogram? (remember it must be in the context)
For the following questions, use the Excel file Practice Final Data, Spring 2013
Use the data Total vs Rural Pop to answer the following 2 questions.
Note: ranges A6:A207, B6:B207, C6:C207, D6:D207 and E6:E207 are already named Country, Total2007, Rural2007, Total2010 and Rural2010. Also, range I6:I207 is named Change.
Question1
a) How many countries are listed in the table?
FormulaAnswer
b) What was the average rural population of the listed countries in 2007?
FormulaAnswer
c) How many countries had a population bigger than 25 million in 2007?
FormulaAnswer
d) What is the total population of the countries that had a population smaller than 20 millions in 2010?
FormulaAnswer
Question 2
Note 1: You must write all formulas in questions (a), (b) and (c) so that you can copy them down the column.
Note 2: a ratio is a quotient of two quantities. For example, if there are 10 women and 15 men, the ratio of women is 10/25=0.4. (it is the same meaning as 40%)
a) Compute in columns F and G the ratio (2 decimals) of rural to total population for each country in 2007 and 2010.
Formula in F6 (for 2007)Ratio for Afghanistan in F6
Formula in G6 (for 2010)
Ratiofor Afghanistan in G6
b) In column H, build a function that will write “Decreased” if the ratio of rural to total population decreased between 2007 and 2010 (cells should remain blank otherwise).
Formula in H6Result in H6
c) In columns I and J, build formulas to compute the change and the percent change of the ratio of rural to total population for each country between 2007 and 2010.
Formula in I6 (change)Change for Afghanistan in I6
Formula in J6 (%-change)
%-Change for Afghanistan in J6
d) Interpret the results in (c).
e) For how many percent of the countries the ratio of rural to total population decreased between 2007 and 2010?
FormulaPercent
f) Interpret the result obtained in question (e). What does it tell you about something important happening in the world today?
Answer