Question

3.An accountant for a large department store would like to develop a model to predict the...

3.An accountant for a large department store would like to develop a model to predict the amount of time it takes to process invoices. Data are collected from the 30 working days and the number of invoices processed and completion time (in hours) are used to obtain the following PHStat output. 1. The value of the t-test statistic to test whether time is linearly dependent on the number of invoices to be processed is? 2. The value of the coefficient of determinations is? 3. TThe accountant is expected to work an additional 0.013 hours (less than a minute) to process an additional invoice. True or false? 4 The value of the standard error of the estimated regression model is?

SUMMARY OUTPUT

Regression Statistics

Multiple R

0.945

R Square

0.892

Adjusted R Square

0.889

Standard Error

0.334

Observations

30

ANOVA

df

SS

MS

F

Significance F

Regression

1

25.944

25.944

232.220

4.3946E-15

Residual

28

3.128

0.112

Total

29

29.072

Coefficients

Standard Error

t Stat

P-value

Intercept

0.402

0.124

3.256

0.003

Invoices Processed

0.013

0.001

15.239

0.000


Homework Answers

Answer #1

Solution :-

1)

From the given output,

The t - value correspoding to the Invoice Processed row = 15.239

Hence,

t-test statistic to test whether time is linearly dependent on the number of invoices to be processed

= 15.239

2)

Value of coefficient of determination

= R - square value given in the output

= 0.892

3)

The statement that the accountant is expected to work an additional 0.013 hours (less than a minute) to process an additional invoice is True.

This is because the coefficient of Invoices processed is0.013 which means that in order to process an additional invoice, the accountant would have to work an additional 0.013 hours.

4)

The value of standard error of estimated regression model is 0.334

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
1. An accountant for a large department store has the business objective of developing a model...
1. An accountant for a large department store has the business objective of developing a model to predict the amount of time it takes to process invoices. Data are collected from the past 32 working days, and the number of invoices processed and completion time (in hours) are stored (invoice.xlsx). (a) At the level ? = 0.01, conduct a t test with the null hypothesis of zero correlation between the number of invoices and the completion time. (b) Using the...
A pharmaceutical science researcher would like to use BMI (body mass index) to predict the insulin...
A pharmaceutical science researcher would like to use BMI (body mass index) to predict the insulin sensitivity. After analyzing the linear regression, we got a summarized output from computer in Table 4. Please answer following questions: (1 point) a) What is dependent variable? b) What is independent variable? c) What is the value of slope here? How to interpret the slope here? d) What is the R square value? How to interpret the R square? e) Please write down a...
Use Excel to develop a regression model for the Hospital Database (using the “Excel Databases.xls” file...
Use Excel to develop a regression model for the Hospital Database (using the “Excel Databases.xls” file on Blackboard) to predict the number of Personnel by the number of Births. Perform a test of the slope. What is the value of the test statistic? Write your answer as a number, round your answer to 2 decimal places. SUMMARY OUTPUT Regression Statistics Multiple R 0.697463374 R Square 0.486455158 Adjusted R Square 0.483861497 Standard Error 590.2581194 Observations 200 ANOVA df SS MS F...
The manager of an amusement park would like to be able to predict daily attendance to...
The manager of an amusement park would like to be able to predict daily attendance to develop more accurate plans about how much food to order and how many ride operators to hire. After some consideration, he decided that the following three factors are critical: Yesterday’s attendance Weekday or weekend (1 if weekend, 0 if a weekday) Predicted weather Rain forecast ( 1 if the forecast for rain, 0 if not) Sun   ( 1 if mostly sunny, 0 if not)...
Zenith Computers, Texas would like to predict weekly Internet sales based on the number of orders....
Zenith Computers, Texas would like to predict weekly Internet sales based on the number of orders. Data (over 15 weeks), relating the sales volume (in thousands of dollars) to the number of orders were available. Regression analysis was performed using Excel. Output related to the regression is given below. Week Orders Sales ($1000) 1 265 15.3 2 150 18.4 3 131 11.6 . . . . . . SUMMARY OUTPUT Regression Statistics Multiple R 0.795 R Square 0.632 Adjusted R...
Question 1 The travel agency Paradise Retreats has developed a model to predict the price per...
Question 1 The travel agency Paradise Retreats has developed a model to predict the price per night of holiday apartment rentals in the coast of Croatia: ?=550+11?1−5?2 ?: price of the apartment per night (in kunas) ?1: area of the apartment (in square meters) ?2: distance to the beach (in km) According to Paradise Retreats’ model: How much more expensive (in kunas) will be the rental of a 60 square-meter apartment on the beachfront compared with a 60 square-meter apartment...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT