The accompanying data file contains 57 months of tax revenue from medical and retail marijuana tax and fee collections. For cross- validation, let the training and the validation sets comprise the first 45 months and the last 12 months, respectively. Click here for the Excel Data File a-1. Use the training set to estimate the linear, the quadratic, and the cubic trend models and compute the resulting MSE, MAD, and MAPE for the validation set. Note: Do not round intermediate calculations. Round final answers to the nearest whole number. Model MSE Linear Quadratic Cubic Answer is not complete. MAD MAPE (%) 15 17 21

The accompanying data file contains 57 months of tax revenue from medical and retail marijuana tax and fee collections. For cross- validation, let the training and the validation sets comprise the first 45 months and the last 12 months, respectively. Click here for the Excel Data File a-1. Use the training set to estimate the linear, the quadratic, and the cubic trend models and compute the resulting MSE, MAD, and MAPE for the validation set. Note: Do not round intermediate calculations. Round final answers to the nearest whole number. Model MSE Linear Quadratic Cubic Answer is not complete. MAD MAPE (%) 15 17 21

Essentials of Business Analytics (MindTap Course List)

2nd Edition

ISBN:9781305627734

Author:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson

Publisher:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson

Chapter3: Data Visualization

Section: Chapter Questions

Problem 3P: The following table provides monthly revenue values for Tedstar, Inc., a company that sells valves...

See similar textbooks

Similar questions

A marketing professor at Givens College is interested in the relationship between hours spent studying and total points earned in a course. Data collected on 156 students who took the course last semester are provided in the tile MktHrsPts. Develop a scatter chart for these data. What does the scatter chart indicate about the relationship between total points earned and hours spent studying? Develop an estimated regression equation showing how total points earned is related to hours spent studying. What is the estimated regression model? Test whether each of the regression parameters β0 and β1 is equal to zero at a 0.01 level of significance. What are the correct interpretations of the estimated regression parameters? Are these interpretations reasonable? How much of the variation in the sample values of total point earned does the model you estimated in part (b) explain? Mark Sweeney spent 95 hours studying. Use the regression model you estimated in part (b) to predict the total points Mark earned.
SKIP THIS IF YOU HAVE ALREADY DONE THIS. THANK YOU
Jay Corporation has provided data from a two-year period to aid in planning. The Controller has asked you to prepare a contribution format income statement. Use the information included in the Excel Simulation and the Excel functions described below to complete the task. • Cell Reference: Allows you to refer to data from another cell in the worksheet. From the Excel Simulation below, if in a blank cell, "=84" was entered, the formula would output the result from cell B4. or 17.000 in this example. • Basle Math funetlons: Allows you to use the basic math symbols to perform mathematical functions. You can use the following keys: (plus sign to add). - (minus sign to subtract). * (asterisk sign to multiply), and / (forward slash to divide). From the Excel Simulation below, if in a blank cell "=B19+B20" was entered, the formula would add the values from those cells and output the result, or 183,.800 in this example. If using the other math symbols the result would output an appropriate…
A business user is analyzing most travelled flight routes in Mid-west area. He is coming up with the count of passengers who flew from one city to another city and total amount (as part of revenue). There are about 120 routes that he is analyzing. He is analyzing flight data month wise for past 6 years. Assuming that the above requirements are complete and will be used for creating a report, identify all the Dimensions and Facts. (Hint: There is 2 fact.)
Assume you have asked your data folks to determine the relationship between customer service scores (i.e. the ratings provided by customers in response to a survey) and profit. The analyst reports the following: "I gathered data for the last 48 months and ran a regression where profit in a given month is the dependent variable and customer service score in that same month is the independent variable. I found an intercept of $10,000 (p-value: 0.31) and the coefficient on customer service score is $1,200 (p-value: 0.22). The R-2 (which is appropriate when there is just one independent variable) is 0.07." What do you infer from the results (two to three sentences, sticking to the information provided) and why?
A sociologist was hired by a large city hospital 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 10 employees was chosen, and the following data were collected. a. Develop a scatter chart for these data. Does a linear relationship appear reasonable? Explain. b. Use the data to develop an estimated regression equation that could be used to predict the number of days absent given the distance to work. What is the estimated regression model? c. What is the 99% confidence interval for the regression parameter 1? Based on this interval, what conclusion can you make about the hypotheses that the regression parameter 1 is equal to zero? d. What is the 99% confidence interval for the regression parameter 0? Based on this interval, what conclusion can you make about the hypotheses that the regression parameter 0 is equal to zero? e. How much of the variation in the sample values of number of days absent does the model you estimated in part (b) explain?
Jensen Tire Auto is deciding whether to purchase a maintenance contract for its new computer wheel alignment and balancing machine. Managers feel that maintenance expense should be related to usage, and they collected the following information on weekly usage (hours) and annual maintenance expense (in hundreds of dollars). a. Develop a scatter chart with weekly usage hours as the independent variable. What does the scatter chart indicate about the relationship between weekly usage and annual maintenance expense? b. Use the data to develop an estimated regression equation that could be used to predict the annual maintenance expense for a given number of hours of weekly usage. What is the estimated regression model? c. Test whether each of the regression parameters 0 and 1 is equal to zero at a 0.05 level of significance. What are the correct interpretations of the estimated regression parameters? Are these interpretations reasonable? d. How much of the variation in the sample values of annual maintenance expense does the model you estimated in part (b) explain? e. If the maintenance contract costs 3,000 per year, would you recommend purchasing it? Why or why not?
A prospective MBA student would like to examine the factors that impact starting salary upon graduation and decides to develop a model that uses program per-year tuition as a predictor of starting salary. Data were collected for 37 full-time MBA programs offered at private universities. The data are stored in the accompanying table. The least-squares regression equation for these data is Y₁ = - 13,863.426 +2.437X, and the standard error of the estimate is Syx = 15,910.578. Assume that the straight-line model is appropriate and there are no serious violations the assumptions of the least-squares regression model. Complete parts (a) and (b) below Click the icon to view the data on program per-year tuition and mean starting salary a. At the 0.01 level of significance, is there evidence of a linear relationship between the starting salary upon graduation and program per-year tuition? Determine the hypotheses for the test. Ho B₁ = D H₁ P₁ #0 (Type integers or decimals. Do not round.)…
Please complete this practice problem by using the 2 images below. Please write cleary and everything in order. Thank you
Financial information for BDS Enterprises for the year-ended December 31, 20xx, was gathered from an accounting intern, who has asked for your guidance on how to prepare an income statement format that will be distributed to management. Subtotals and totals are included in the information, but you will need to calculate the values. A. In the correct format, prepare the income statement using the following information: B. Calculate the profit margin, return on investment, and residual income. Assume an investment base of $100,000 and 6% cost of capital. C. Prepare a short response to accompany the income statement that explains why uncontrollable costs are included in the income statement.
Tempe Office Services and Supplies (TOSS) provides various products and services in the Tempe Research Park, home to numerous high-tech and bio-tech companies. Making color copies is one of its most popular and profitable services. The controller performed a regression analysis of data from the Color Copy Department with the following results: Intercept R-squared Number of observations X coefficient Month July August September October November December The regression output was based on the following data: Number of Color Copies 25,900 23,000 19,550 18, 150 22,150 20,400 Req 1 30.874686 0.970922 Req 2 6 0.081144 Required: 1. What is the variable cost per color copy for TOSS? 2. What is the fixed cost for the Color Copy Department? 3. Based on the regression output obtained by the controller, what cost formula should be used to estimate future total costs for the Color Copy Department? Enter answer as an equation in the form of y= a + bx. Variable cost per color copy Fixed cost Color…
After a few hours May’s computer is fixed. May uses the first 9 months of data and regression analysis to estimate the relationship between the quantity purchased and purchase costs of part #696. The regression line May obtains is as follows: y = $2,582.6 + 3.54X Evaluate the regression line using the criteria of economic plausibility, goodness of fit, and significance of the independent variable. Compare the regression equation to the equation based on the high-low method. Which is a better fit? Why?