Question

100 96 24 2000 = 100 18 90 88 95 84 1966 1967 1968 1969 1990 1991 1992 1993 1994 1995 196 197 198 1999 2000 2001 2002 2003 2004 2005 2005 Year Source: Statistics Canada's Internet Site, http://estat.statcan.ca/cgi-win/cnsmcgi.exe, CANSIM table 387-000 V28546044, December 16, 2007. a. By approximately how many index points did the CPI change from 1990 to 2003? b. Express this change as a percent to the nearest hundredth. Is this change an increase or decrease in the price of goods? C. Estimate how much a cup of coffee cost in 1998 when it cost $1.59 in 1987

Answer 1

a)In 1990 , the index point is 92.

In 2003 the index point is 98.

Therefore the change in index points from 1990 to 2003 is 98-92 = 6 index point. approximately

b) expressing this change in nearest hundred = $\frac{(new number - original number)*100}{originalnumber}$

=$\frac{(98 - 92)*100}{92}$

=

= 6.5217 %

c) Cpi in 1987 approximately = 86.67

Cpi in 1990 approcimately = 100.5

Price of coffee in 1987 = $1.59

As per the formula,

(Price of coffee in 1990 *cpi in 1987)/ cpi in 1990 = price of coffee in 1987

Price of coffee in 1990 = (price of coffee in 1987 * cpi in 1990 )/ cpi in 1987

= $\frac{1.59 * 100.5}{86.67}$

=

159.795 86.67

=1.843 $

thus the price of coffe in 1998 would cost $ 1.843

Question 7)

a)Independent variable = classes missed

dependent cariable = Student marks

- . Cla Book1 - Microsoft Excel Home Insert Page Layout Formulas Data Review View X Σ AutoSum Calibri 11 Α Α΄ 2 Wrap Text General Fill * Cut En Copy Paste Format Painter Clipboard B I U *Merge & Center % 4.0 .00 .00 0 Insert Delete Format Conditional Format Cell Formatting as Table Styles Styles 2 Clear Sort & Find & Filter - Select Font E Alignment Number Cells Editing B21 for A С D E F G H - K L M N O P Q 1 classes missed 2 2 B Student marks 63 80 76 1 3 4 1 5 10 47 Student marks vs classes missed 6 2 72 90 7 25 35 max y alue = 82 8 4 80 82 80 9 4 70 10 5 60 11 2 71 60 12 13 50 13 49 81 70 2 4 Marks obtained 14 40 Student marks 15 2 30 - Linear (Student marks) 38 59 16 1 maxx value = 25 20 17 18 Co relation coefficient 19 -0.652984252 10 0 20 0 5 10 15 20 25 30 21 22 classes missed 23 24 25 Sheet4 Sheets Sheet6 Sheet1 Sheet2 Sheet3 Ready BE 100% U Type here to search O 5 la 4x ENG 15:48 31-07-2020

b) Equation of best fit is : Line of Best fit (y) = -1.5958 * x + 72.4982

. Cla Book1 - Microsoft Excel Home Insert Page Layout Formulas Data X Review View Σ AutoSum Calibri 11 Α Α΄ Wrap Text General Fill * Cut E Copy Paste Format Painter Clipboard B I U Merge & Center - % 4.0 .00 .00 0 Insert Delete Format Conditional Format Cell Formatting as Table Styles Styles 2 Clear Sort & Find & Filter Select Editing Font E Alignment Number Cells A1 for SUMMARY OUTPUT E F H - J K F A B с D 1 SUMMARY OUTPUT 2 3 Regression Statistics 4 Multiple R 0.652984252 5 R Square 0.426388433 6 Adjusted R Square 0.382264467 7 Standard Error 12.41008837 8 Observations 15 9 10 ANOVA 11 df SS MS 12 Regression 1488.266188 1488.266 13 Residual 13 2002.133812 154.0103 14 Total 14 3490.4 15 16 Coefficients Standard Error t Stat 17 Intercept 72.49828884 4.170534691 17.38345 18 classes absent -1.595824778 0.513357333 -3.1086 19 20 Line of best fit = bx +a 21 (classes missed coefficient) *x + intercept 22 Line of Best fit (y) = -1.5958 *x + 72.4982 23 Significance F 0.008308021 1 9.663420256 P-value 2.21052E-10 0.008308021 Lower 95% 63.48839643 -2.704865868 Upper 95% 81.50818125 Lower 95.0% Upper 95.0% 63.48839643 81.50818125 -2.704865868 -0.486783687 -0.486783687 24 25 Sheet4 Sheet5 Sheet6 Sheet1 Sheet2 Sheet3 Ready BE 100% i Type here to search O a 4x ENG 15:38 31-07-2020

c) The co relation coefficient as given in the above images is

R = -0.6529

The corelation coefficient tells us the students marks are negatively co- related with the classes missed. it means that more the classes are missed , less are the marks obtained by students. Also the strength of co relation betrween marks and and classes missed is moderate to good

If you find the above answers helpful please upote and comment. Thank you