First I created a scatter plot of the data given for yellow golf balls and calculated the linear regression for it. Screenshots are attached.
The regression equation (equation for the line of best fit) was y = 16488x + 189312, where x represents the year number and y is the total yellow golf balls.
We are concerned with year 4, so we will substitute 4 for x: y = 16488(4) + 189312 = 255,264
There will be around 255,264 yellow golf balls sold in year 4.
Since the ratio of yellow to white golf balls is 1:5, we can set up a proportion: 1/5 = 255264/x
Cross multiply: 1*x = 5*255264 x = 1,276,320
We expect the company to sell 1,276,320 white golf balls. This makes a total of:
1,276,320 + 255,264 = 1,531,584 total golf balls expected to be sold in year 4.
Since these are sold in boxes of 12, we divide this by 12: 1,531,584/12 = 127,632 boxes expected to be sold
