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

Chapter7: Linear Regression

Section: Chapter Questions

Problem 4P: A sociologist was hired by a large city hospital to investigate the relationship between the number...

See similar textbooks

Similar questions

Solar Solutions began operations on January 1, 2015, and is now in its sixth year of operations. It is a retail sales company with a large amount of online sales. The adjusted trial balance as of December 31, 2020 appears below, along with prior year balance sheet data and some additional transaction data for 2020. SOLAR SOLUTIONS Adjusted Trial Balance 12/31/2020 2020 2019 Account Title Adjusted Trial Balance Post-Closing Trial Balance Debit Credit Debit Credit Cash $ 122,200 55,000 125,600 Accounts Receivable 35,000 Prepaid Insurance 5,000 6,000 |Inventory Office Equipment Machinery & Tools Accumulated Depreciation Accounts Payable Salaries Payable Sales Tax Payable Note Payable-Long Term Common Stock, $10 par 46,000 15,600 63,000 47,000 59,000 21,000 21,000 16,000 11,200 16,800 2,600 2,700 2,000 4,000 31,000 22,100 240,000 160,000 Retained Earnings 28,600 28,600 Dividends 10,000 Sales Revenue Cost of Goods Sold Rent Expense Salaries Expense 235,000 127,600 20,000 36,000 Insurance…
Use the assumptions below to create calculations to determine annual and monthly revenue projections for each of the categories. Be sure to make the revenue category on the pro-forma view (above) descriptive and use your assumptions as drivers for the values calculated. Make it easy to change the assumptions to determine the impact of a change (up or down) in volume, rates and discounts. Insert lines or columns as needed. Camps and Schools require physicals before kids arrive. There are 150 camper physicals spread evenly in May and June. There are 500 school physicals, 25% in July, 65% in August, and 10% in September. The insurance companies in covering families in your community are split 50% BC/BS and 40% United Healthcare and no insurance (private pay). Your normal camper physical charge is $115. You give BC/BS an 18% discount and United Health care a 15% discount. The special promotion for campers without insurance (private pay) is $75. Camper Physical $ 115 Payor -…
In cell B10, enter a formula using the IF and AND functions to indicate whether the revenue goal has been met that month: a. Enter the logical test using the AND Function to determine if the Fundraisers amount in cell B7 equals 0 and the Total in cell B8 is greater than 20,000. b If the logical test is true, display Yes (using "Yes" for the value_if_true argument). c. If the logical test is false, insert a nested IF function. d. Enter the logical test of the nested IF function using the AND function to determin if the Fundraiser amount in cell B7 is greater than 0 and the Total in cell B8 is greater than 200,000. e. If the logical test for the nested IF function is true, display YES ( using "Yes" for the value_if_true argument). f. If the logical test if false, display No (using "No" for the value_if_false argument) I have tried to figure this excel formula out for about an hour now, this is what I have. but this is only half of the formula. I need the correct formula please.…
A five-year earnings summary for Motors, Inc. is presented in the following table. Using this data, construct a single graph of the three earnings measures, and then prepare a memo addressing the following items. What type of graph did you create and why? Present your graphs in your memo. Does there appear to be a relationship among the earnings measures? Explain why or why not. Assess your chart's design in terms of presentation bias. If you feel your chart is free from bias, explain why this is so. Then develop a second chart with the data presented in a manner that might be misleading to a viewer. MOTORS: Earnings Measures, 2008-2012 \table[[Year,2012,2011,2010,2009,200],[\table[[Income],[from],[operations]],5,785,6,450,7,250,6,250,5,975,],[\table[[Net],[income]],4,385,5,300,5,325,4,737,4,529,],[\table[[Net cash],[flow from],[operations]],5,050,8,300,7,700,7,530,5,700,]]
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.)
The initial analysis should include the following: The ratio equation The calculation of the ratio using the equation and the pre-assigned Quick Study or Exercise from the textbook. Use the result in a sentence; i.e. For every dollar invested in assets the company is earning 22.4 cents or 22.4% in net income. Then explain whether this is a good result or a result that needs improving. Use citations to cite any outside sources used. The original post should include at least three (3) sentences but no more than seven (7) sentences.
The initial analysis should include the following: The ratio equation The calculation of the ratio using the equation and the pre-assigned Quick Study or Exercise from the textbook. (See below) Use the result in a sentence; i.e. For every dollar invested in assets the company is earning 22.4 cents or 22.4% in net income. Then explain whether this is a good result or a result that needs improving. Use citations to cite any outside sources used. The original post should include at least three (3) sentences but no more than seven (7) sentences. SHOW WORK
Here is the operating data for Yalis Cleaning, Inc.: After analyzing the transactions, prepare a vertical analysis schedule for the company for 2021 and 2020 using service revenue as the base amount. Round percentages to two decimal places.
The accompanying data provides the results of a survey of 27 employees in a tax division of a Fortune 100 company. a. Test the null hypothesis that the average number of years of service is the same for males and females. Assume that the population variances are unequal. b. Test the null hypothesis that the average years of undergraduate study is the same for males and females. Assume that the population variances are unequal. Click the icon to view the survey data. a. Is there sufficient evidence at the 0.01 level of significance that the average number of years of service is the same for males and females? Determine the null hypothesis, Ho, and the alternative hypothesis, H₁. Let females be population 1 and males be population 2. Ho P-P2 H₁: P₁ - H = 0 (Type integers or decimals. Do not round.) Compute the test statistic. - 3.65 (Round to two decimal places as needed.) Find the p-value for the test. (Round to three decimal places as needed.)
The accompanying data provides the results of a survey of 27 employees in a tax division of a Fortune 100 company. a. Test the null hypothesis that the average number of years of service is the same for males and females. Assume that the population variances are unequal. b. Test the null hypothesis that the average years of undergraduate study is the same for males and females. Assume that the population variances are unequal Click the icon to view the survey data. a. Is there sufficient evidence at the 0.01 level of significance that the average number of years of service is the same for males and females? Determine the null hypothesis, H. and the alternative hypothesis. H Let females be population 1 and males be population 2 Ho H1 H2 = 0 HH-H # 0 (Type integers or decimals. Do not round.) Compute the test statistic (Round to two decimal places as needed.) Survey data Gender Years of Service Years Undergraduate Study Gender Years of Service Years Undergraduate Study Female 18 4 Male 6…
A. Based on the above and the result of your audit, answer the following(Round off present value factors to four decimal places and final answers to nearest hundred) 1. The consultation service fee revenue that should be recognized in 2022 is
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?