Finish all the charts completely,

Answer options for #4: Only F is a reliable estimate, Only V is a reliable estimate, both F and V are reliable estimates, and Neither F and V are reliable estimates.

Question #5: Using a P-Value of 0.05 for significance, the following is true:

Options: Only F is a reliable estimate, Only V is a reliable estimate, Both F and V are reliable estimates, or neither F and V are reliable estimates.

Question 6. In the McCourt Company example, _____ percent of the variability in materials handling cost was explained by changes in the number of moves. As a result, McCourt may want to search for additional explanatory variables. For example, the weight of the items moved might be usefulparticularly if forklifts and other heavy machinery are needed for moving parts and products from one location to another.

McCourt Company had the following 10 months of data on materials handling cost and number of moves: Materials Handling Cost Number of Moves 475 125 175 600 $5,600 3,090 780 8,000 1,990 300 300 250 400 100 1. Using the above data on material handling, using regression software such as regression function within Microsoft Excel, and fill in the missing data in the table below (round answers to two decimal places) McCourt Company SUMMARY OUTPUT Regression Statistics Multiple R R Square Adjusted R Square Standard Error 0.94 0.87 746.14 10 ANOVA Regression 33,414,382.28 33,414,382 60.02 ,453,817.72 556,727.20 9 37,868,200.00 Standard Error tStat P-value 996.27 16.99 1.93 0.09 .75 0.000055 X Variable 1 2. McCourt estimates that November will now have 350 moves. Using this new value, calculate the following expected total, fixed and variable costs for the month of November (round all costs to the nearest dollar): Expected fixed cost Expected variable cost Total cost 3. What is the percentage of material handing cost explained by moves: 11.68 1.51 9,600 48,000 57,600 88 percent 4. Using a P-value of 0.10 for significance, the following is true Applying the Concepts The stalf of controller of McCourt Company added the variable "pounds moved to the ten-morth data set: Month Materials Handling Cost $5,600 3,090 Number of Moves 475 125 175 600 Pounds Moved 15,000 7,800 29,000 600 23,000 17,000 25,000 6,000 22,400 780 8,000 1,990 300 250 400 100 4,300 1. Using the data on material handling, use regression software such as Microsoft Excel to complete the missing data in the table below (round regression parameters to the nearest cent and other answers to three decimal places): McCourt Company SUMMARY OUTPUT Multiple R R Square Adjusted R Square Standard Error 0.999 119.600 10 ANOVA Regression 2 37,768,070.16 18,884,035 1,320.168 9.50629E-10 Residual 7 100,129.84 14,304.26 9 37,868,200.00 Standard Errort Stat P-value 86.068 6.863 0.000239 0.340 0.340 9.81E-0B 5E-07 X Variable 1 X Variable 2 0.006 17.446 2. Using the cost equation from Requirement 1, calculate the total expected material handling cost for November if 350 moves are expected and 17,000 pounds of material will be moved (round final answer to the nearest dollar). Expected material handling cost: 3. For the coming year, McCourt expects 3,940 moves involving a total of 204,000 pounds. Calculate the following: Total expected fixed costs (round to the nearest dollar): Total material handing cost (add each component in the equation and then round to the nearest dollar): McCourt Company had the following 10 months of data on materials handling cost and number of moves: Materials Handling Cost Number of Moves 475 125 175 600 $5,600 3,090 780 8,000 1,990 300 300 250 400 100 1. Using the above data on material handling, using regression software such as regression function within Microsoft Excel, and fill in the missing data in the table below (round answers to two decimal places) McCourt Company SUMMARY OUTPUT Regression Statistics Multiple R R Square Adjusted R Square Standard Error 0.94 0.87 746.14 10 ANOVA Regression 33,414,382.28 33,414,382 60.02 ,453,817.72 556,727.20 9 37,868,200.00 Standard Error tStat P-value 996.27 16.99 1.93 0.09 .75 0.000055 X Variable 1 2. McCourt estimates that November will now have 350 moves. Using this new value, calculate the following expected total, fixed and variable costs for the month of November (round all costs to the nearest dollar): Expected fixed cost Expected variable cost Total cost 3. What is the percentage of material handing cost explained by moves: 11.68 1.51 9,600 48,000 57,600 88 percent 4. Using a P-value of 0.10 for significance, the following is true Applying the Concepts The stalf of controller of McCourt Company added the variable "pounds moved to the ten-morth data set: Month Materials Handling Cost $5,600 3,090 Number of Moves 475 125 175 600 Pounds Moved 15,000 7,800 29,000 600 23,000 17,000 25,000 6,000 22,400 780 8,000 1,990 300 250 400 100 4,300 1. Using the data on material handling, use regression software such as Microsoft Excel to complete the missing data in the table below (round regression parameters to the nearest cent and other answers to three decimal places): McCourt Company SUMMARY OUTPUT Multiple R R Square Adjusted R Square Standard Error 0.999 119.600 10 ANOVA Regression 2 37,768,070.16 18,884,035 1,320.168 9.50629E-10 Residual 7 100,129.84 14,304.26 9 37,868,200.00 Standard Errort Stat P-value 86.068 6.863 0.000239 0.340 0.340 9.81E-0B 5E-07 X Variable 1 X Variable 2 0.006 17.446 2. Using the cost equation from Requirement 1, calculate the total expected material handling cost for November if 350 moves are expected and 17,000 pounds of material will be moved (round final answer to the nearest dollar). Expected material handling cost: 3. For the coming year, McCourt expects 3,940 moves involving a total of 204,000 pounds. Calculate the following: Total expected fixed costs (round to the nearest dollar): Total material handing cost (add each component in the equation and then round to the nearest dollar)