1. Using the unemployment data provided, investigate the association between the male unemployment rate in 2007 and 2010 for a sample of 52 countries. (If you use EXCEL please show me how you solved this please - it would be great help to see the steps) Thank you!

Find a regression model predicting the 2010 rate from the 2007 rate for the sample of 52 countries . State in simple language what the model says.

2010 Index = ___________ + _____________________ x 2007 Index (Round to two decimal places as needed.)

State in simple language what the model says. Select the correct choice below and fill in the answer box to complete your choice.

(Round to two decimal places as needed.)

0 A. For each 1% increase in the 2007 rate, the 2010 rate increased by ____________

0 B. The 2010 rate increased by______________________ per year.

0 C. The 2007 rate increased by _______________per year.

0 D. For each 1% increase in the 2010 rate, the 2007 rate increased by ___________________

Determine the test statistic. t = ____________ (Round to two decimal places as needed.)

Determine the P-value. P-value = _____________ (Round to three decimal places as needed.)

Make a conclusion.

Since the P-value is (1) ________________ the significance level, a, (2)_____________________ the null hypothesis.

The association (3) ______________significant

(1)      0 less than                       

          0 greater than

      (2)      0 do not reject

                0 reject

    (3)     0 is

   0 is not

Please use excel and demonstrate the formulae used.

A new project will cost $32,356 initially and will last for 7 years, at which time its salvage value will be $2,500. Annual revenues are anticipated to be $15,000 per year. For a MARR of 6% percent every year, plot a sensitivity graph for annual worth versus initial cost, annual revenue, and salvage value, varying only one parameter at a time, each within the range of +/- 50% increments of 10%.

1. For the data below create a table in excel and a graph to accompany. (the table and graph are two separate supplements so make sure each is labeled and formatted properly.) Hint: You are making the table in excel because you can make the graph straight from the data.

Each group recorded the level of carbon monoxide measured (ppm) in a running car every 15 seconds for 2 minutes with a Graywolf indoor/outdoor air quality monitor. They start recording at zero seconds.

Group 1, 1994 Ford Focus: 58, 50, 42, 36, 30, 25, 25, 24, 23

Group 2, 2008 Ford F150: 12, 15, 15, 16, 17, 16, 15, 14, 15

Group 3, 1988 Chevy Nova: 112, 80, 80, 70, 60, 55, 45, 40, 40

Group 4, 2014 Honda Accord: 12, 14, 16, 20, 30, 30, 35, 40, 48

Group 5, 2010 Hyundai Santa Fe: 50, 45, 43, 42, 30, 23, 13, 8, 7

Group 6, 2003 Subaru Forester: 66, 45, 40, 33, 32, 21, 20, 120, 17

2. Create a table in Microsoft word for the following data.

Scientists tracked and observed a Black Bear (Ursus Americanus) named Stachi over the course of 6 years. Once a year they would document her weight and height, geolocation, fetal development, and body condition.

December 1999- 97 lbs., 55 in., (39.7576202, -74.1062466), No, Average

December 2000- 135 lbs., 55 in., (39.695866, -74.253511), Yes, Fat

December 2001- 102 lbs., 55 in., (39.5585, -74.3706), No, Average

December 2002- 99 lbs., 55 in., (39.7576202, -74.1062466), No, Average

December 2003- 122 lbs, 55 in., (39.695866, -74.253511) Yes, Fat

December 2004- 70 lbs., 54 in., (39.49026, -74.53915), No, Thin

A perfectly competitive TV production firm in Lost Angeles faces the above short-run cost schedule.
The price per unit of output is £16.

a) How much (supernormal) profit is made at this output?
b) What would happen to the price in the long run if this firm were typical of others in the industry?   
c) What would happen to costs and revenues if the Canadian government intervened in this market to encourage firms to move production to Vancouver, Canada?  
d) While television production is up, the US television station industry is collapsing thanks to the internet and Netflix. To what extend should government intervene in the markets prone to market failure?

The results of the blood pressure measurements taken of the same patient by fourteen different second-year medical students are listed in the table below.

                         Systolic        Diastolic

                            138              82

                            130              91

                            135              100

                            140              100

                            120              80

                            125              90

                            120              80

                            130              80

                            130              80

                            144              98

                            143              105

                            140              85

                            130              70

                            150              100

a. Use a 5% level of significance to test whether there is a significant linear correlation between the two variables {use hypothesis test for the slope}

b. For a given systolic blood pressure of 125, identify the 95% prediction interval estimate for the slope (diastolic blood pressure). Write a statement interpreting your interval in the context of this example.

Periodic Inventory by Three Methods; Cost of Merchandise Sold

The units of an item available for sale during the year were as follows:

There are 80 units of the item in the physical inventory at December 31. The periodic inventory system is used.

Determine the inventory cost and the cost of merchandise sold by three methods. Round interim calculations to one decimal and final answers to the nearest whole dollar.

Question 2:

In this part, we will use t-procedures. t-procedures are both confidence intervals and hypothesis tests that

use a t distribution. They are called t-procedures because they rely on a t-test statistic and/or a t-critical

value, so we only need to know the results of a sample in order to perform these procedures for a population

You will use the data file TempSample00-18.

(THIS is Temp sample data)

YEAR,Month,High Temperature

2000,Jan,45

2000,Jan,48

2001,Jan,49

2003,Jan,62

2003,Jan,53

2004,Jan,42

2004,Jan,47

2005,Jan,40

2005,Jan,47

2006,Jan,48

2006,Jan,47

2007,Jan,51

2007,Jan,34

2007,Jan,47

2009,Jan,50

2011,Jan,35

2012,Jan,44

2013,Jan,38

2013,Jan,53

2013,Jan,42

2014,Jan,58

2014,Jan,47

2014,Jan,44

2015,Jan,52

2016,Jan,44

2017,Jan,49

2018,Jan,54

2000,Feb,48

2001,Feb,47

2004,Feb,47

2007,Feb,51

2008,Feb,51

2008,Feb,55

2011,Feb,45

2014,Feb,37

2014,Feb,54

2014,Feb,58

2015,Feb,54

2017,Feb,52

2017,Feb,44

2017,Feb,45

This includes an SRS of daily temperature highs from January and February from the years 2000-2018

(i.e. “recent” highs). The distribution of “recent” daily high temperatures is approximately Normal.

A.

1) Describe the intended population?

2) Describe the sample?

3) Describe the variable of interest?

4) Describe the parameter of interest (in context)?

5) Describe the statistic of interest (in context)? Give a numerical value along with your description.

Round to two decimal places.

B.

1) Check that the conditions for using t-procedures are satisfied. If they are not, discuss whether or not it is reasonable to use t-procedures.

C.

1) What degrees of freedom are needed?

2) What critical value is used to compute a 95% confidence interval?

3) Give the 95% confidence interval. Round to two decimal places.

4) Interpret your 95% confidence interval.

D.

1) Perform a hypothesis test for α = .01. Be sure to interpret your p-value in context.

E.

1) Based on your work in Part B, what would you say about the daily high temperature for “recent” years compared to “historical” years?

Question 2:

In this part, we will use t-procedures. t-procedures are both confidence intervals and hypothesis tests that

use a t distribution. They are called t-procedures because they rely on a t-test statistic and/or a t-critical

value, so we only need to know the results of a sample in order to perform these procedures for a population

You will use the data file TempSample00-18.

(THIS is Temp sample data)

YEAR,Month,High Temperature

2000,Jan,45

2000,Jan,48

2001,Jan,49

2003,Jan,62

2003,Jan,53

2004,Jan,42

2004,Jan,47

2005,Jan,40

2005,Jan,47

2006,Jan,48

2006,Jan,47

2007,Jan,51

2007,Jan,34

2007,Jan,47

2009,Jan,50

2011,Jan,35

2012,Jan,44

2013,Jan,38

2013,Jan,53

2013,Jan,42

2014,Jan,58

2014,Jan,47

2014,Jan,44

2015,Jan,52

2016,Jan,44

2017,Jan,49

2018,Jan,54

2000,Feb,48

2001,Feb,47

2004,Feb,47

2007,Feb,51

2008,Feb,51

2008,Feb,55

2011,Feb,45

2014,Feb,37

2014,Feb,54

2014,Feb,58

2015,Feb,54

2017,Feb,52

2017,Feb,44

2017,Feb,45

This includes an SRS of daily temperature highs from January and February from the years 2000-2018

(i.e. “recent” highs). The distribution of “recent” daily high temperatures is approximately Normal.

A.

1) Describe the intended population?

2) Describe the sample?

3) Describe the variable of interest?

4) Describe the parameter of interest (in context)?

5) Describe the statistic of interest (in context)? Give a numerical value along with your description.

Round to two decimal places.

B.

1) Check that the conditions for using t-procedures are satisfied. If they are not, discuss whether or not it is reasonable to use t-procedures.

C.

1) What degrees of freedom are needed?

2) What critical value is used to compute a 95% confidence interval?

3) Give the 95% confidence interval. Round to two decimal places.

4) Interpret your 95% confidence interval.

D.

1) Perform a hypothesis test for α = .01. Be sure to interpret your p-value in context.

E.

1) Based on your work in Part B, what would you say about the daily high temperature for “recent” years compared to “historical” years?

Exercise 18.1

Effects of transactions on statement of cash flows

Below is a list of transactions completed by Direct Fashion during 2020. Ignore GST. For each transaction, indicate (a) the section (i.e. operating, investing or financing) of the statement of cash flows (SCF) in which the cash effect is reported (if the effect is not reported in any of the sections, place NA on the line); (b) the amount; (c) whether the effect would be an inflow (+) or outflow (–).

Transaction      (a) Section of SCF      (b) Amount         (c) Inflow (+) Outflow (– )

1. Accounts receivable decreased by $30 000 during the year

2. Sold for $50 000 cash equipment with a carrying amount of $25 000

3. The owner contributed cash of $40 000   

4. Purchased a motor vehicle for $27 000, giving $7 000 cash and by borrowing $20 000

5. Declared and paid dividends of $20 000

6. Paid interest on borrowings of $2000   

7. Purchased equity investments for $50 000 cash

8. Repaid fixed-term loan principal of $40 000   

9. Accounts payable decreased by $15 000 during the year

10. Owner withdrew $18 000 in cash for personal use