Question
Plantcity is a large nursery and retail store specializing in house and garden plants and supplies. Jean Raouth, the assistant manager, is in the process
Plantcity is a large nursery and retail store specializing in house and garden
plants and supplies. Jean Raouth, the assistant manager, is in the process of
budgeting monthly supplies expense for 2019. She assumes that in some way
supplies expense is related to sales, either in units or in dollars. She has
collected these data for sales and supplies expenses for June 2016 through
December 2018, and has estimated sales for 2019.DataDateSupplies
ExpenseSales (Units)Sales (Dollars)June-16$2,745354$20,090July-163,200436$21,900August-163,232525$28,780September-162,199145$18,560October-162,321199$21,680November-163,432543$21,520December-164,2781,189$24,630January-172,310212$19,990February-172,573284$21,900March-172,487246$18,940April-172,484278$21,340May-173,384498$32,100June-172,945424$28,500July-172,758312$22,650August-173,394485$24,350September-172,254188$18,930October-172,763276$22,320November-173,245489$30,040December-174,5761,045$33,090January-182,103104$21,950February-182,056167$20,450March-183,874298$23,010April-182,784398$23,450May-182,345187$18,150June-182,912334$20,940July-182,093264$19,340August-182,873333$20,540September-182,563143$19,770October-182,384245$18,570November-182,476232$21,890December-183,3641,122$34,330January-19180$16,000February-19230$20,000March-19190$19,000April-19450$24,000May-19350$23,000June-19350$23,000July-19450$25,000August-19550$30,000September-19300$25,000October-19300$25,000November-19450$32,000December-19950$39,000
Required
1. Develop the regression that Jean should use based on the data andevaluate the reliability and precision of the regression you have chosen.
2. What are the predicted monthly figures for supplies expense for 2019?
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started