need answers for these questions, solve it in Excel

Given the LTL rate tariff in Table 4.10, compute the effective rate of 3000-lb shipment and a 4200-lb shipment. Do the effective rates diffe Why or why not? Using the Excel linear regression functions, develop a power cur expression (y = Cxb) to estimate the effective rate, in $/cwt, for a Cla 85 shipment from Cleveland, OH (Hopkins International Airport ar ZIP code 44135) to Research Triangle Park, NC (ZIP code 27709). U the CzarLite web site cited in this chapter (http://smc3apps.smc3.com Applications/WebCzarLite/Entry.asp) to obtain the rate data and em it into Excel. Assume that your carrier has agreed to provide a disco of 46% from these rates (including the minimum charge), approximat the same as the estimated national average discount for LTL repor TABLE 4.10 Rate Tariff for Exercise 4.6 Weight Group Minimum Weight (lb) Freight Rate ($/cwt) 1 (L5C) 1 30.60 2 (M5C) 500 28.15 22.03 3 (M1M) 1,000 4 (M2M) 18.05 2,000 5 (M5M) 14.21 5,000 6 (M10M) 11.85 10,000 7 (M20M) 6.90 20,000 8 (M30M) 5.31 30,000 9 (M40M) 4.87 40,000 Minimum charge = $83.24. by Kay and Warsing (2009). What are the actual and estimated rates for a 8500-lb shipment on the Cleveland-RTP lane? Compute weight breaks for the M5C (500-lb) and M5M (5000-1 groups for the CLE-RTP lane using the rate data from Exercis mrding to the Kay and Warsing (2009) paper cited in this ch Class 85 shipment is 12.72 lb/ft. Using t