Revenue Problem South Shore Construction builds permanent docks and seawalls along the southern shore of Long Island, New York. Although the firm has been in business only five years, revenue has increased from $308,000 in the first year of operation to $1,084,000 in the most recent year. The data for this problem can be downloaded at the beginning of this quiz. The data gives quarterly sales revenue for the last five years.This question relates to the Revenue Problem. Develop an equation to account for seasonal effects in the time series. Let Q1 = 1 if quarter 1, 0 otherwise; Q2 = 1 if quarter 2, 0 otherwise; Q3 = 1 if quarter 3, 0 otherwise. What is the coefficient on the Q3 variable? Round your answer to the nearest whole number.This question relates to the Revenue Problem. Based on the regression model that considers the seasonal effects in the data, compute an estimate for the revenue in Year 6 Quarter 4. Round your answer to the nearest whole number. This question relates to the Revenue Problem. Develop an equation to account for seasonal effects and any linear trend in the time series. Define t to be the period. Let t = 1 refer to the observation in quarter 1 of year 1, t = 2 refer to the observation in quarter 2 of year 1, etc. What is the coefficient on the Q3 variable? Round your answer to the nearest whole number.This question relates to the Revenue Probiem. Based on the regression model that considers both seasonal effects in the data and linear trend, compute an estimate for Year 6 Quarter 3. Round your answer to the nearest whole number. A B C D E F G H Year Quarter Revenue 1 20000 100000 W N 175000 4 13000 10 00 JO UI A W N 2 37000 W N - 136000 245000 26000 10 75000 11 155000 W N 12 326000 13 48000 14 4 92000 15 W N H 202000 16 384000 17 82000 18 5 176000 19 282000 W N 20 445000 21 181000 22