SUMMARY OUTPUT Regression Statistics Multiple R 0.950979617 R Square 0.904362232 Adjusted R Square 0.901064378 Standard Error 36929223.21 Observations 31 ANOVA df SS Regression 1 3.73983E+17 Residual 29 3.95493E+16 Total 30 4.13532E+17 Coefficients Standard Error Intercept 3113071000 -83609875.87 0.162875504 38484675.46 0.009835587 ignificance F MS F 3.73983E+17 274.227487 2.5497E-16 1.36377E+15 t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0% -2.17254985 0.03812917 -162319875 -4899876.9 -162319875 -4899876.9 16.55981541 2.5497E-16 0.14275947 0.18299154 0.14275947 0.18299154 Estimate the prediction equation using data that is not currently being audited. Predicted quarterly revenue = + ( x per passenger mile flown Identify the following statistical data. Coefficient t-Statistic p-Value (two-sided) Intercept Quarterly passenger miles flown PROBLEM G&J Airlines is a regional airline in the United States. Over the past five years, the average quarterly revenue was $660 million. Although the airline is not a public company, its financials are audited annually to support debt financing. G&J Airlines has a December 31 year-end, and the audit associated with this application of ADA focuses on the year 2025. Data by quarter for 2014 through 2022 are presented here. Available Passenger Period 1Q-2017 2Q-2017 Revenues Passengers Seat Miles Miles Flown $472,407,000 2,324,000 4,346,680,000 3,113,071,000 474,038,848 2,507,000 4,436,515,000 3,421,369,000 3Q-2017 468,272,917 2,522,000 4Q-2017 476,830,974 2,377,000 1Q-2018 508,507,000 2,335,000 2Q-2018 530,291,000 2,543,000 4,638,174,000 3,594,398,000 4,441,701,000 3,182,573,000 4,452,075,000 3,135,685,000 4,732,988,000 3,537,967,000 3Q-2018 461,204,000 2,718,000 4,563,071,000 3,362,241,000 4Q-2018 360,789,000 1,973,000 3,779,876,000 2,648,755,000 1Q-2019 2Q-2019 454,772,000 2,328,000 413,486,000 2,502,000 4,227,178,000 3,084,440,000 4,623,651,000 3,420,954,000 3Q-2019 451,868,000 2,698,000 4,694,191,000 3,518,672,000 4Q-2019 373,030,000 2,671,000 4,368,050,000 3,179,253,000 1Q-2020 423,652,000 2,390,000 4,324,274,000 2,977,593,000 2Q-2020 459,752,000 2,706,000 4,406,846,000 3,346,266,000 3Q-2020 490,664,000 2,848,000 4,734,232,000 3,742,946,000 4Q-2020 466,183,000 2,658,000 1Q-2021 478,631,000 2,957,000 2Q-2021 529,669,000 3,020,000 3Q-2021 659,544,000 3,083,000 4,545,021,000 3,404,979,000 4,703,320,000 3,372,407,000 5,010,373,000 3,886,929,000 5,119,087,000 4,133,195,000 4Q-2021 505,602,000 2,957,000 4,893,776,000 3,784,025,000 1Q-2022 519,710,000 2,930,000 4,893,154,000 3,757,676,000 2Q-2022 592,739,000 3,224,000 3Q-2022 622,615,000 3,300,000 4Q-2022 590,249,000 3,205,000 5,286,722,000 4,209,959,000 5,567,012,000 4,514,938,000 5,336,100,000 4,156,224,000 1Q-2023 2Q-2023 611,411,000 3,235,000 727,594,000 3,651,000 5,862,863,000 5,418,465,000 4,219,087,000 4,847,925,000 3Q-2023 729,876,000 3,595,000 6,070,954,000 4,987,967,000 2Q-2024 4Q-2023 654,772,000 3,444,000 5,659,751,000 1Q-2024 539,835,000 3,356,000 5,653,527,000 769,710,000 3,759,000 6,139,419,000 4,517,012,000 4,450,207,000 5,108,506,000 3Q-2024 792,532,000 4,004,000 6,295,851,000 5,274,274,000 4Q-2024 730,913,000 3,472,000 5,923,237,000 4,703,320,000 1Q-2025 2Q-2025 809,005,000 3,549,000 3Q-2025 804,814,000 3,727,000 4Q-2025 700,664,000 3,411,000 5,887,137,000 4,622,407,000 6,287,137,000 5,152,697,000 6,303,527,000 5,134,025,000 720,125,000 3,110,000 5,487,137,000 4,320,539,000