Assume that Kents Tulip Time does a regression analysis on the next years data using Excel 2007.
Question:
Requirement
1. Determine the firms cost equation (use the output from the Excel regression).
2. Determine the R-square (use the output from the Excel regression). What does Tulip Times R-square indicate?
3. Predict van operating costs at a volume of 15,500 kilometres.
Transcribed Image Text:
Regression Statistics Multiple R R Square Adjusted R Square Standard Error Observations 0.85 0.72 0.66 205.01 ANOVA af MS Significance F 0.0158 Regression Residual Total 539222.81 539222.81 210148.62 42029.72 749371.43 12.83 5 6 Lower 95.0% Upper 95.0% 2704.12 4061.65 -2704.12 4061.65 0.51 Lower Upper 95% Coefficients 678.76 0.29 Standard Error 1316.00 0.08 t Stat 0.52 3.58 P-value 0.63 0.02 95% Intercept X Variable 1 0.08 0.51 0.08
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Answer rating: 61% (13 reviews)
Req 1 Based on the Excel output Tulip Times van operating cost equatio...View the full answer
Answered By
Ali Khawaja
my expertise are as follows: financial accounting : - journal entries - financial statements including balance sheet, profit & loss account, cash flow statement & statement of changes in equity -consolidated statement of financial position. -ratio analysis -depreciation methods -accounting concepts -understanding and application of all international financial reporting standards (ifrs) -international accounting standards (ias) -etc business analysis : -business strategy -strategic choices -business processes -e-business -e-marketing -project management -finance -hrm financial management : -project appraisal -capital budgeting -net present value (npv) -internal rate of return (irr) -net present value(npv) -payback period -strategic position -strategic choices -information technology -project management -finance -human resource management auditing: -internal audit -external audit -substantive procedures -analytic procedures -designing and assessment of internal controls -developing the flow charts & data flow diagrams -audit reports -engagement letter -materiality economics: -micro -macro -game theory -econometric -mathematical application in economics -empirical macroeconomics -international trade -international political economy -monetary theory and policy -public economics ,business law, and all regarding commerce
4.00+
1+ Reviews
10+ Question Solved
Related Book For
Managerial Accounting
ISBN: 978-0176223311
1st Canadian Edition
Authors: Karen Wilken Braun, Wendy Tietz, Walter Harrison, Rhonda Pyp
Question Posted:
Students also viewed these Managerial Accounting questions
-
Assume that Flower Power does a regression analysis on the next years data using Excel. The output generated by Excel is as follows: Requirements 1. Determine the firms cost equation (use the output...
-
Assume that Posies Unlimited does a regression analysis on the next years data using Excel. The output generated by Excel is as follows: Requirements 1. Determine the firms cost equation (use the...
-
Assume that Flowers Direct does a regression analysis on the next year's data using Excel. The output generated by Excel is as follows: Requirements 1. Determine the firm's cost equation (use the...
-
An investment at 10.47% effective annual rate compounded monthly is equal to an annual percentage rate of: A. 10.99% B. 9.57% C. 10% D. None of the above If the one-year discount factor is 0.8333,...
-
Explain the long-run effect of Chinas current exchange rate policy. The Bush administration has declined to cite China for manipulating its currency to gain unfair trade advantages against the United...
-
It is now December 31, 2015 (t = 0) , and a jury just found in favor of a woman who sued the city for injuries sustained in a January 2014 accident. She requested recovery of lost wages plus $300,000...
-
Explain medical staff organization and committee structure.
-
The space truss is supported by a ball-and-socket joint at D and short links at C and E. Determine the force in each member and state if the members are in tension or compression. Given: F1 = (200...
-
Use the exact interest method (365 days) and the ordinary interest method (360 days) to compare the amount (in $) of interest for the loan. (Round your answers to two decimal places.) Principal Rate...
-
A hydrocarbon liquid enters a simple flow system shown in fig. at an average velocity of 1.282 m/s, where A1=4.33x10-3m2and 1=902 kg/m3. The liquid is heated in the process and the exit density is...
-
Refer to the Tulip Time data in E6-49B. Use Microsoft Excel to run a regression analysis, then do the following calculations. Requirements 1. Determine the firms cost equation (use the output from...
-
Cliffs Fresh Stacks Pancake Restaurant features sourdough pancakes made from a strain of sourdough dating back to Confederation. To plan for the future, Cliff needs to figure out his cost behaviour...
-
A 20-gallon barrel, as shown in Figure 23, leaks at the constant rate of 0.1 gallon per day. Sketch a plot of the height h of the water as a function of timer, assuming that the barrel is full at...
-
How can we reverse a singly circular linked list? .
-
List all types of linked list. Explain circular linked list in detail.
-
What is mean by dangling pointer explain with an example?
-
What are the advantages of linked list over array?
-
What are the differences between dangling pointer and memory leak?
-
(a). Define budgetary control and explain its objectives. (b). Define how functional budgets are built up, taking any one specific example.
-
For each equation, (a) Write it in slope-intercept form (b) Give the slope of the line (c) Give the y-intercept (d) Graph the line. 7x - 3y = 3
-
Division A manufactures electronic circuit boards. The boards can be sold either to Division of the same company or to outside customers. Last year, the following activity occurred Division A: Sales...
-
Alpha and Beta are divisions within the same company. The managers of both divisions are evaluated based on their own divisions return on investment (ROI). Assume the following information relative...
-
Alpha and Beta are divisions within the same company. The managers of both divisions are evaluated based on their own divisions return on investment (ROI). Assume the following information relative...
-
If a tax Bear has a vacation home, that is issues personally by the taxpayer for part of the year, and as a rental for part of the year, how are expenses reported on its tax return?
-
Christopher and Janai have a new grandson. How much money should they invest now so that he will have $78,000 for his college education in 18 years? The money is invested at 3.8% compounded...
-
Jonas' current annual salary is $70,000. Ten years from now how much will he need to earn to retain his present purchasing power if the rate of inflation over that period is 2% /year compounded...
Study smarter with the SolutionInn App