logo

Crowdly

Browser

Add to Chrome

Based on the regression output generated in Lab 3.5 Excel, Deriving Cost Driver...

✅ The verified answer to this question is available below. Our community-reviewed solutions help you understand the material better.

Based on the regression output generated in Lab 3.5 Excel, Deriving Cost Drivers for Activity-Based Costing (Regression Analysis), which of the following statements about the cost drivers for overhead cost per delivery is true? Assume alpha is set at 0.05.

The excel sheet titled summary output contains 3 tables. The table at top contains 2 columns and 6 rows with the following sub-title: regression statistics. The row entries are as follows: row 2 - multiple R; 0.89679396. Row 3 - R square; 0.80423941. Row 4 - adjusted R square; 0.79926245. Row 5 - standard error; 4.49411051. Row 6 - observations; 122. The table below titled Anova contains 6 columns and 4 rows. The headings of columns 2 to 6 are as follows: d f; S S; M S; F; significance F. The row entries are as follows: row 2 - regression; 3; 9791.057335; 3263.685778; 161.5923672; 1.2764E-41. Row 3 - residual; 118; 2383.249459; 20.19702932; blank; blank. Row 4 - total; 121; 12174.30679; blank; blank; blank. The table below contains 7 columns and 5 rows. The headings of columns 2 to 7 are as follows: coefficients; standard error; t stat; P-value; lower 95%; upper 95%. The row entries are as follows: row 2 - intercept; 15.6744488; 2.968641478; 5.280007332; 5.96789E-07; 9.795730433; 21.55316711. Row 3 - miles per delivery; 0.45479993; 0.096881262; 4.694405458; 7.27182E-06; 0.262948651; 0.646651202. Row 4 - time per delivery; 1.88046082; 0.117656896; 15.98258056; 2.66501E-31; 1.64746813; 2.113453501. Row 5 - weight per delivery; -0.0022603; 0.002852916; -0.792275398; 0.429790028; -0.00790985; 0.003389256.

❌
❌
✅
❌
More questions like this

Want instant access to all verified answers on moodle.polytechnic.bh?

Get Unlimited Answers To Exam Questions - Install Crowdly Extension Now!

Browser

Add to Chrome

TelegramInstagramTikTokQuestion Bank
Terms of UseContact Us