Reference no: EM13502023

Question 1: Suppose Procter & Gamble sells about 20 million bars of soap per week, but the demand is not constant, and production management would like to get a better handle on how sales are distributed over the year. Let the following sales figures, given in units of million bars, represent the sales of bars per week over one year. Construct a histogram to represent this data. What do you see in the graph that might be helpful to the production (and sales) people?

Mth 1	17.1	17.1	17	25.2
Mth 2	19.6	12.2	18.3	26.3
Mth 3	15.4	19.9	13.6	23.9
Mth 4	17.4	18.7	39.8	30.6
Mth 5	15	20.4	20.7	25.2
Mth 6	18.5	20.3	21.3	26.2
Mth 7	20.6	15.5	22.5	26.9
Mth 8	18.4	16.8	21.4	32.8
Mth 9	20	19.1	23.4	26.3
Mth 10	20.9	20.4	23.1	26.6
Mth 11	19.3	15.4	22.8	24.3
Mth 12	18.2	20.3	21.4	26.2
Mth 13	14.7	17.5	24	23.8

Question 2: A Travel Weekly International Air Transport Association survey asked business travellers about the purpose for their most recent business trip. 19% responded that it was for an internal company visit. Suppose 950 business travellers are randomly selected.

(a)        What is the probability that more than 25% of the business travellers say that the reason for their most recent business trip was an internal company visit?

(b)        What is the probability that between 15% and 20% of the business travellers say that the reason for their most recent business trip was an internal company visit?

(c)        What is the probability that between 133 and 171 of the business travellers say that the reason for their most recent business trip was an internal company visit?

Please be sure to include all workings with your answers.

Question 3 : Where do CFOs get their money news? According to Robert Half International, 47% get their money news from newspapers, 15% get it from communication/colleagues, 12% get it from television, 11% from the internet, 9% from magazines, 5% from radio, and 1% do not know. Suppose a researcher wants to test these results. They randomly sample 67 CFOs and find that 40 of them get their money news from newspapers.

Does the test show enough evidence to reject the findings of Robert Half International?

Use    = 0.05.

Note: You will need to explain how you determined the answer to the question. Submitting answers without an explanation for this question is not sufficient.

Question 4 : Shown below are a set of rental and leasing revenue figures for office machinery and equipment over a seven-year period. Use this data to run a linear regression and then forecast the rental and leasing revenue for the year 2012. You will need to use the charting features in Excel for this question.

	Year	Rental and leasing
		($ millions)
2005		5,860
2006		6,632
2007		7,125
2008		6,000
2009		4,380
2010		3,326
2011		2,642

Question 5 : Suppose a researcher gathered survey data from 19 employees and asked the employees to rate their job satisfaction on a scale from 0 to 100 (with 100 being perfectly satisfied). Suppose the following data represents the results of this survey. Also assume that:

• the relationship with the supervisor is rated on a scale from 0 to 50 (0 represents a poor relationship and 50 represents an excellent relationship)

• overall quality of the work environment is rated on a scale from 0 to 100 (0 represents a poor work environment and 100 represents an excellent work environment)

• opportunities for advancement is rated on a scale from 0 to 50 (0 represents no opportunities and 50 represents excellent opportunities).

Answer the following questions:

(a)        What is the regression formula?

(b)        How reliable do you think the estimates will be based on this formula? How can you tell?

(c)        Are there any variables that do not appear to be good predictors of job satisfaction? How can you tell?

(d)        If a new employee reports that her relationship with her supervisor is 40, finds the quality of the work environment to be scored at 75, works 60 hours per week and rates her opportunities for advancement to be at 30, what would you expect her job satisfaction score to be?

Note: You will need to use the regression tool from the Analysis Toolpak or KADDstat.

	Relationship with	Overall quality of	Total hours	Opportunities for
Job satisfaction	supervisor	work environment	worked per week	advancement
55	27	65	50	42
20	12	13	60	28
85	40	79	45	7
65	35	53	65	48
45	29	43	40	2
70	42	62	50	41
35	22	18	75	18
60	34	75	40	32
95	50	84	45	48
65	33	68	60	11
85	40	72	55	33
10	5	10	50	21
75	37	64	45	42
80	42	82	40	46
50	31	46	60	48
90	47	95	55	30
75	36	82	70	39
45	20	42	40	22
65	32	73	55	12

 

Question 6

Investment analysts generally believe the interest rate on bonds are inversely related to the interest rate for loans; that is, bonds perform well when lending rates are down and perform poorly when interest rates are up. Can the bond rate be predicted by the interest rate?

Use the following data to construct a scatter graph and then fit a regression line to the data. Report the regression formula and the r-squared value from the chart (right-click on the line, select 'Add Trendline' and select options to show these metrics).

Bond rate	Prime interest rate
(%)	(%)
5	16
12	6
9	8
15	4
7	7

 

Note: You will need to use the regression tool from the Analysis Toolpak or KADDstat.

Question 7 : Determine the error for each of the following forecasts. Compute MAD and MSE.

Period value	Forecast	Error
1	202	-
2	191	202
3	173	192
4	169	181
5	171	174
6	175	172
7	182	174
8	196	179
9	204	189
10	219	198
11	227	211

Question 8 : Shown below is data on factory orders for all manufacturing, durable goods, and non-durable goods industries over a 13-year period ($ billion).

(a)        Use this data to develop forecasts for the years 6 through 13 using a 5-year moving average.

(b)        Use this data to develop forecasts for the years 6 through 13 using a 5-year weighted moving average. Weight the most recent year by 6, the previous year by 4, the year before that by 2, and the other years by 1.

(c)        Compute the errors of the forecasts in parts (a) and (b) and then the mean absolute deviation (MAD). Which forecast is better?

 

Year		Factory orders
		($ billions)
1	2,512.7
2	2,739.2
3	2,874.9
4	2,934.1
5	2,865.7
6	2,978.5
7	3,092.4
8	3,356.8
9	3,607.6
10	3,749.3
11	3,952.0
12	3,949.0
13	4,137.0

Question 9 : The 'Economic Report to the Director' included data on the amounts of manufacturers' new and unfilled orders in millions of dollars. Shown below are the figures for new orders over a 21-year period. Use Excel to develop a regression model to fit the trend effects for the data. Use a linear model and then try a quadratic model. How well does either model fit the data? For this question you will need to use the regression tool from the Analysis Toolpak.

Year	Total number
	of new orders
1	55,022
2	55,921
3	64,182
4	76,003
5	87,327
6	85,139
7	99,513
8	115,109
9	131,629
10	147,604
11	156,359
12	168,025
13	162,140
14	175,451
15	192,879
16	195,706
17	195,204
18	209,389
19	227,025
20	240,758
21	243,643