Madison County Airport handles several daily commuter flights and many private flights. The county budget officer has co

[answerhappygod]

Madison County Airport handles several daily commuter flights
and many private flights. The county budget officer has compiled
the following data regarding airport costs and activity over the
past year.
Construct an Excel spreadsheet and use the Excel commands
to perform a least-squares regression. Estimate the variable- and
fixed-cost components in the airport’s cost behavior
pattern. (Do not round your intermediate
calculations.)
Monthly Fixed cost:
Variable cost per flight:
I need help figuring out how to construct the excel
sheet and what formulas to use to then find the monthly fixed cost
and variable cost per flight. Could I have a detailed explanation
of what formulas you put in each cell?