Skip to main content

BA6933-Week-5 Asst( 13 & 14)

Given are five observations collected in a regression study on two variables.

2

6

9

13

20

7

18

9

26

23

a. Which of the following scatter diagrams accurately represents the data?

A.

Chart

Description automatically generated

B.

A picture containing light

Description automatically generated

C.

Chart, scatter chart

Description automatically generated

D.

A picture containing light

Description automatically generated

 

b. Develop the estimated regression equation for these data (to  decimal).

  

  

      

c. Use the estimated regression equation to predict the value of  when  (to  decimal).

  



Hide Feedback

Correct

Brawdy Plastics, Inc., produces plastic seat belt retainers for General Motors at their plant in Buffalo, New York. After final assembly and painting, the parts are placed on a conveyor belt that moves the parts past a final inspection station. How fast the parts move past the final inspection station depends upon the line speed of the conveyor belt (feet per minute). Although faster line speeds are desirable, management is concerned that increasing the line speed too much may not provide enough time for inspectors to identify which parts are actually defective. To test this theory, Brawdy Plastics conducted an experiment in which the same batch of parts, with a known number of defective parts, was inspected using a variety of line speeds. The following data were collected.

Excel file: 
data14-05.xlsx

Line
Speed

Number of
Defective
Parts Found

20

23

20

21

30

19

30

16

40

15

40

17

50

14

50

11

If required, enter negative values as negative numbers.

a. Select a scatter diagram with the line speed as the independent variable.

A.

Application

Description automatically generated with medium confidence

B.

Application

Description automatically generated with medium confidence

C.

Chart

Description automatically generated with medium confidence

D.

Table

Description automatically generated with medium confidence

 

b. What does the scatter diagram developed in part (a) indicate about the relationship between the two variables?
 

c. Use the least squares method to develop the estimated regression equation (to 1 decimal).

      

d. Predict the number of defective parts found for a line speed of  feet per minute.
 



Hide Feedback

Correct

David's Landscaping has collected data on home values (in thousands of $) and expenditures (in thousands of $) on landscaping with the hope of developing a predictive model to help marketing to potential new clients. Data for  households may be found in the file Landscape. Click on the datafile logo to reference the data.

If required, enter negative values as negative numbers.

a. Select a scatter diagram with home value as the independent variable.

A.

Chart, scatter chart

Description automatically generated

B.

Chart, scatter chart

Description automatically generated

C.

Chart, scatter chart

Description automatically generated

 

b. What does the scatter plot developed in part (a) indicate about the relationship between the two variables?

The scatter diagram indicates a   linear relationship between the two variables.

c. Use the least squares method to develop the estimated regression equation (to  decimals).

   +  

d. For every additional  in home value, estimate how much additional will be spent on landscaping (to  decimals).

$   

e. Use the equation estimated in part (c) to predict the landscaping expenditures for a home valued at  (to the nearest whole number).

$   



Hide Feedback

Correct

A large city hospital conducted a study to investigate the relationship between the number of unauthorized days that employees are absent per year and the distance (miles) between home and work for the employees. A sample of  employees was selected and the following data were collected.

Excel file: 
data14-13.xlsx

Distance to Work

Number of Days

(miles)

Absent

1

8

3

5

4

8

6

7

8

6

10

3

12

5

14

2

14

4

18

2

If required, enter negative values as negative numbers.

a. Select the correct scatter diagram for these data.

A.

Chart, scatter chart

Description automatically generated

B.

Chart, scatter chart

Description automatically generated

C.

Chart, scatter chart

Description automatically generated

 

Does a linear relationship appear reasonable?

 

b. Develop the least squares estimated regression equation that relates the distance to work to the number of days absent (to  decimals).

      

c. Predict the number of days absent for an employee that lives  miles from the hospital (to nearest whole number).

  days



Hide Feedback

Correct

Given are five observations for two variables,  and .

Excel File: data14-17.xlsx

The estimated regression equation for these data is  .

Compute SSE, SST, and SSR (to  decimal).

SSE

 

SST

 

SSR

 

What percentage of the total sum of squares can be accounted for by the estimated regression equation (to  decimal)?

  

What is the value of the sample correlation coefficient (to  decimals)?

 



Hide Feedback

Correct

An important application of regression analysis in accounting is in the estimation of cost. By collecting data on volume and cost and using the least squares method to develop an estimated regression equation relating volume and cost, an accountant can estimate the cost associated with a particular manufacturing volume. Consider the following sample of production volumes and total cost data for a manufacturing operation.

 

Production Volume (units)

Total Cost ($)

400

4,000

450

5,000

550

5,400

600

5,900

700

6,400

750

7,000


a. Use these data to develop an estimated regression equation that could be used to predict the total cost for a given production volume. Do not round intermediate calculations.

Compute  and  (to  decimal).  
 
 
 

Complete the estimated regression equation (to  decimal). Do not round intermediate calculations
 
     

b. What is the variable cost per unit produced (to  decimal)? Do not round intermediate calculations
 
 

c. Compute the coefficient of determination (to  decimals). Do not round intermediate calculations. Note: report  between  and .
 
 

What percentage of the variation in total cost can be explained by the production volume (to  decimal)? Do not round intermediate calculations
  

d. The company's production schedule shows  units must be produced next month. Predict the total cost for this operation (to the nearest whole number). Do not round intermediate calculations
 
 



Hide Feedback

Correct

Given are five observations for two variables,  and .

Excel File: data14-25.xlsx

The estimated regression equation is .

a. What is the value of the standard error of the estimate (to  decimals)?

 

b. Test for a significant relationship by using the t test. Use .

What is the value of the t test statistic (to  decimals)?

 

What is the -value? Use Table 2 of Appendix B.

 .

What is your conclusion ()?

 

c. Use the  test to test for a significant relationship. Use .

Compute the value of the  test statistic (to  decimals).

 

What is the -value? Use Table 4 of Appendix B.

 

What is your conclusion?

 



Hide Feedback

Correct

Consider the following data on production volume  and total cost  for a particular manufacturing operation.

Excel File: 
data14-29.xlsx

Production Volume (units)

Total Cost ($)

400

4,000

450

5,000

550

5,400

600

5,900

700

6,400

750

7,000

 

The estimated regression equation is .

Use  to test whether the production volume is significantly related to the total cost.

Complete the ANOVA table. Enter all values with nearest whole number, except the  test statistic (to  decimals) and the -value (to  decimals).

Source of
Variation

Degrees of
Freedom

Sum
of Squares

Mean
Square


F

p-value

Regression

 

 

 

 

 

Error

 

 

 

 

Total

 

 

 

 

What is your conclusion?

 



Hide Feedback

Correct

Consider the data set below. Use Table 2 of Appendix B.

Excel File: data14-33.xlsx

a. Estimate the standard deviation of  when  (to  decimals).

 

b. Develop a  confidence interval for the expected value of  when  (to  decimals).

 ,   )

c.Estimate the standard deviation of an individual value of  when  (to  decimals).

 

d. Develop a  prediction interval for  when  (to  decimals).

 ,   )



Hide Feedback

Correct

Data given below are on the adjusted gross income  and the amount of itemized deductions taken by taxpayers. Data were reported in thousands of dollars. With the estimated regression equation , the point estimate of a reasonable level of total itemized deductions for a taxpayer with an adjusted gross income of  is . Click on the datafile to reference the data.

Excel File: data14-37.xlsx

Adjusted Gross

Reasonable Amount of Itemized

Income ($1000s)

Deductions ($1000s)

22

9.6

27

9.6

32

10.1

48

11.1

65

13.5

85

17.7

120

25.5

Use the estimated regression coefficients rounded to  decimals in your calculations.

а. Develop a  confidence interval for the mean amount of total itemized deductions for all taxpayers with an adjusted gross income of  (to  decimals).

$    thousand to $    thousand

b. Develop a  prediction interval estimate for the amount of total itemized deductions for a particular taxpayer with an adjusted gross income of  (to  decimals).

$    thousand to $    thousand

c. If the particular taxpayer referred to in part (b) claimed total itemized deductions of , would the IRS agent's request for an audit appear to be justified?

 , it is   than anticipated.

d. Use your answer to part (b) to give the IRS agent a guideline as to the amount of total itemized deductions a taxpayer with an adjusted gross income of  should claim before an audit is recommended (to the nearest whole number).

Any deductions exceeding the $    upper limit could suggest an audit.



Hide Feedback

Correct

The Wall Street Journal asked Concur Technologies, Inc., an expense management company, to examine data from  million expense reports to provide insights regarding business travel expenses. Their analysis of the data showed that New York was the most expensive city. The following table shows the average daily hotel room rate () and the average amount spent on entertainment () for a random sample of  of the  most-visited U.S. cities. These data lead to the estimated regression equation . For these data . Click on the datafile logo to reference the data. Use Table 1 of Appendix B.

City

Room Rate
($)

Entertainment
($)

Boston

148

161

Denver

96

105

Nashville

91

101

New Orleans

110

142

Phoenix

90

100

San Diego

102

120

San Francisco

136

167

San Jose

90

140

Tampa

82

98

a. Predict the amount spent on entertainment for a particular city that has a daily room rate of  (to  decimals).
 
 

b. Develop a  confidence interval for the mean amount spent on entertainment for all cities that have a daily room rate of  (to  decimals).
 
  to   

c. The average room rate in Chicago is . Develop a  prediction interval for the amount spent on entertainment in Chicago (to  decimals).
 
  to   



Hide Feedback

Correct

Following is a portion of the regression output for an application relating maintenance expense (dollars per month) to usage (hours per week) for a particular brand of computer terminal.

Excel File: data14-41.xlsx

ANOVA

 

df

SS

MS

F

Significance F

Regression

1

1575.76

Residual

8

349.14

Total

9

1924.90

 

Coefficients

Standard Error

t Stat

P-value

Intercept

6.1092

0.9361

Usage

0.8951

0.149

If your answer is zero, enter "".

a. Write the estimated regression equation (to  decimals).

   +   

b. Use a  test to determine whether monthly maintenance expense is related to usage at the  level of significance (to  decimals). Use Table 2 of Appendix B.

 

-value 

 

  the null hypothesis. Monthly maintenance expense   related to usage.

c. Did the estimated regression equation provide a good fit? Explain. Hint: If  is greater than , the estimated regression equation provides a good fit.

 , because the value of  is   than .



Hide Feedback

Correct

Given are the data for two variables,  and . Do not round your intermediate calculations.

 

a. Develop an estimated regression equation for these data by computing  and  (to  decimals). Enter negative values as negative numbers.

  

  

      

b. Compute the residuals (to  decimals). Enter negative values as negative numbers.

 

 

 

 

 

c. Consider the following three scatter diagrams of the residuals against the independent variable. Which of the following accurately represents the data?

1.

Chart, scatter chart

Description automatically generated

2.

3.

Chart, scatter chart

Description automatically generated

 

Do the assumptions about the error terms seem to be satisfied?

 

d. Compute the standardized residuals. Enter negative values as negative numbers.

standardized residual

  (to  decimal places)

  (to  decimal places)

  (to  decimal places)

  (to  decimal places)

  (to  decimal places)

e. Select a correct plot of the standardized residuals against .

1.

A picture containing timeline

Description automatically generated

2.

Timeline

Description automatically generated with low confidence

3.

A picture containing chart

Description automatically generated

 

What conclusions can you draw from this plot?

 



Hide Feedback

Correct

Consider the following data for two variables, x and y.

Excel File: data14-51.xlsx

a. Consider the three scatter diagrams below.

1

Chart, line chart

Description automatically generated

2

Chart, line chart

Description automatically generated

3

Chart, line chart

Description automatically generated

Which scatter diagram accurately represents the data?
 

Does the scatter diagram indicate any influential observations?

 

b. Compute the standardized residuals for these data (to  decimals, if necessary). Enter negative values as negative numbers.

Observation 1

 

Observation 2

 

Observation 3

 

Observation 4

 

Observation 5

 

Observation 6

 

Observation 7

 

Observation 8

 

Do the data include any outliers?
 

c. Compute the leverage values for these data (to  decimals). Enter negative values as negative numbers.

Observation 1

 

Observation 2

 

Observation 3

 

Observation 4

 

Observation 5

 

Observation 6

 

Observation 7

 

Observation 8

 

Does there appear to be any influential observations in these data?
 



Hide Feedback

Correct

Retail chain Kroger has more than  locations and is the largest supermarket in the United States based on revenue. Kroger has invested heavily in data, technology, and analytics. Feeding predictive models with data from an infrared sensor system called QueVision to anticipate when shoppers will reach the checkout counters, Kroger is able to alert workers to open more checkout lines as needed. This has allowed Kroger to lower its average checkout time from four minutes to less than  seconds (Retail Touchpoints).

Consider the data in the file Checkout. The file contains  observations. Each observation gives the arrival time (measured in minutes before  p.m.) and the shopping time (measured in minutes).

a. Select the correct scatter diagram for arrival time as the independent variable.

A.

Chart, scatter chart

Description automatically generated

B.

Chart, scatter chart

Description automatically generated

C.

Chart, scatter chart

Description automatically generated

 

b. What does the scatter diagram developed in part (a) indicate about the relationship between the two variables?

There appears to be a   relationship between the two variables.

Does there appear to be any outliers and/or influential observations?

Observation   appears to be an observation with high leverage and may be very influential in terms of fitting a linear model to the data.

c. Using the entire data set, develop the estimated regression equation that can be used to predict the shopping time given the arrival time (to  decimals).

      

d. Use residual analysis to determine whether any outliers or influential observations are present.

Observation   has a standardized residual  , indicating it is an outlier.

e. After looking at the scatter diagram in part (a), suppose you were able to visually identify what appears to be an influential observation. Drop this observation from the data set and fit an estimated regression equation to the remaining data (to  decimals).

      

Compare the estimated slope for the new estimated regression equation to the estimated slope obtained in part (c). Does this approach confirm the conclusion you reached in part (d)? Explain.

The slope of the estimated regression equation is now   as compared to a value of   when this observation is included. Thus, we see that this observation   a impact on the value of the slope of the fitted line and hence we   that it is an influential observation.



Hide Feedback

Correct

The Toyota Camry is one of the best-selling cars in North America. The cost of a previously owned Camry depends upon many factors, including the model year, mileage, and condition. To investigate the relationship between the car's mileage and the sales price for a  model year Camry, the following data show the mileage and sale price for  sales (PriceHub website). Click on the datafile logo to reference the data.

Miles (1000s)

Price ($1000s)

22

16.2

29

16.0

36

13.8

47

11.5

63

12.5

77

12.9

73

11.2

87

13.0

92

11.8

101

10.8

110

8.3

28

12.5

59

11.1

68

15.0

68

12.2

91

13.0

42

15.6

65

12.7

110

8.3

If your answer is zero, enter "".

a. Select a scatter diagram with the car mileage on the horizontal axis and the price on the vertical axis.

1.

2.

3.

 

b. What does the scatter diagram developed in part (a) indicate about the relationship between the two variables?

 

c. Develop the estimated regression equation that could be used to predict the price (s) (to  decimals).

      

d. Test for a significant relationship at the  level of significance (to  decimals).

-value      .

e. Did the estimated regression equation provide a good fit?

 

f. Provide an interpretation for the slope of the estimated regression equation (to  decimals but dollar value to the nearest cent). Enter negative values as negative numbers.

The slope of the estimated regression is  . Therefore, every additional  miles on the car's odometr will result in a     in the predicted price.

g. Suppose that you are considering purchasing a previously owned  Camry that has been driven  miles. Using the estimated regression equation developed in part (c), predict the price for this car (round to nearest dollar).

  

Is this the price you would offer the seller?

 



Hide Feedback

Correct

  

Comments

Popular posts from this blog

IS5203 Type 2 Post Assessment and Final Quiz

  Carlos has just created a new subnet for the finance department. He needs to be able to allow the employees in finance to retrieve files from the sales server, which is located in another subnet. Which of the following OSI model layers would it be necessary to categorize the device into? a. Layer 4 b. Layer 6 c. Layer 2 d. Layer 3 All of the cubicles in a company's office have cables that run up to the ceiling and across to an IDF. Inside the IDF, they connect directly to the latest generation switch available from the networking equipment vendor that they have chosen. Which of the following describes the physical topology most likely in use? a. mesh

GE5103-2 Project Management [Aug 23 Syllabus]

    Some of the advantages of using time boxes and cycles in project coordination efforts include creating urgency, measuring progress, and allowing for predictable measurements. A)        True 2.    Even though most project managers are not contract specialists, they need to understand the process well enough to coordinate with the team. For the current assignment, you are looking at a short-term and small effort with a contractor of just a few hours without significant clarity. Which of the following would be the most applicable contract to use in this situation? A)        Time and materials 3. The project you are working on has had modifications to the plan from the start and even how the project is run. Project governance covers all of the 3 following except: A)        Naming The project manager 4. Of the following, which is most likely a trigger condition defined early in the project? A) Alerting Governance board if 10 percent over schedule 5. Of the following options, which stand

GE5163 Week8 ( Final Exam ) Quize's

  A process or product that is insensitive to normal variation is referred to as being Select one: a. in specification b. capable c. robust d. out of control Feedback Your answer is correct. A completed failure mode and effects analysis (FMEA) results in the following assessment rating.      Occurrence = 4      Severity = 8      Detection = 10 What is the risk priority number (RPN) for this FMEA? Select one: a. 42 b. 22 c. 320 d. 120 Feedback Your answer is correct. In a visual inspection situation, one of the best ways to minimize deterioration of the quality level is to: Select one: a. have a program of frequent eye exams. b. retrain the inspector frequently. c. add variety to the task. d. have a standard to compare against as an element of the operation. Feedback Your answer is correct. Which of the following elements is least necessary to a good corrective action feedback report? Select one: a. What caused the failure b. Who caused the failure c. What correction has been made d. Wh