HELLO! I need the formulas for the assignment and how to do the chart please dont just give me the answers! im trying to learn this!

PROTECTED VIEW Be careful-files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View. Enable Editing A1 X fx Lobsters AA | AB | AC | AD AE | AF AG | AH Al | AJ AK AM AN Historical Maine Lobster Landings a.) Use the Historical Maine Lobster Landings data to answer the following questions. YEAR SPECIES METRIC TONS POUNDS POUNDS(million: VALUE VALUE(million: PRICE/LB 1950 LOBSTER, AMERICAN 8325 ####### 18.3526 $6,412,311 6.4123 1951 LOBSTER. AMERICAN 9416 ####### 20. 7595 $7.214,107 7.2141 3.) compute the price per pound for lobster every year. Format 1952 LOBSTER, AMERICAN 9088 ####### 20.0363 $8,511,821 8.5118 as currency. 1953 LOBSTER, AMERICAN 10115 ####### 22.3003 $8,411,229 8.4112 1954 LOBSTER, AMERICAN 9828 ####### 21.6677 $8,087.156 .0872 1955 LOBSTER, AMERICAN 10305 ####### 22. 7181 $8,716,012 8.716 .) compute the Descriptive Statistics for the Pounds sample 1956 LOBSTER, AMERICAN 9331 ####### 20.5723 $9,119,807 9. 1198 data using Excel's built-in functions. Format to 0 decimal 1957 LOBSTER, AMERICAN 11069 ####### 24.4028 $8,954,234 8.9542 places with commas. 1958 LOBSTER, AMERICAN 37 ####### 21.312 ######### 10.445 1959 LOBSTER, AMERICAN 10128 ####### 22.3288 $11,252,686 11.2527 b. ) Pounds 1960 LOBSTER, AMERICAN 10893 ####### 24.0142 $10,967,018 10.967 Mean 1961 LOBSTER, AMERICAN 9488 ####### 20.9179 $11,119,803 11. 1198 Max 1962 LOBSTER, AMERICAN 10013 ####### 22.0753 $11,195,609 11. 1956 Min 1963 LOBSTER, AMERICAN 10344 ####### 22.8043 ######### 12.6358 Range 1964 LOBSTER. AMERICAN 9490 ####### 20.9207 ######### 13.8783 Count 1965 LOBSTER, AMERICAN 8556 ####### 18.8618 $14,177,204 14. 1772 St Dev 966 LOBSTER, AMERICAN 9034 ###### 19.9158 ######### 14.9045 1967 LOBSTER. AMERICAN 7479 ####### 16.4892 ######### 13.5979 1968 LOBSTER, AMERICAN 9299 ####### 20.5017 $14,931,671 14.9317 c.J d.) 1969 LOBSTER, AMERICAN 8997 ####### 19.8348 ######### 6.0468 Cutoffs Counts Bins (in millions Frequency c.) compute the Counts in the table for the Histogram of this 1970 LOBSTER, AMERICAN 8243 ####### 18.1723 $17,201,501 17.2015 20,000,000 0..20 data set using the COUNTIF function as explained in this 1971 LOBSTER, AMERICAN 7964 ####### 17.5584 $17,481,29 17.4813 30,000,000 20..3 chapter to count the years when the Pounds are below each 1972 LOBSTER, AMERICAN 7374 ####### 16.2565 ######### 18.5875 40,000,000 30..40 cutoff. Format to 0 decimal places. 1973 LOBSTER, AMERICAN 7731 ####### 17.0442 #########1 23.2699 50,000,000 40..5 1974 LOBSTER, AMERICAN 7465 ####### 16.4577 ########## 23.2128 60,000,000 50..60 1975 LOBSTER, AMERICAN 7491 ####### 16.5156 ########## 26.5201 70,000,000 60.. 70 1976 LOBSTER, AMERICAN 8619 ####### d.) Complete the Histogram table by computing the 19.0011 ######### 29.2384 80,000,000 70..80 Frequencies as explained in the chapter. Format to O decimal 977 LOBSTER, AMERICAN ####### 8.4871 $32,101,423 32. 1014 places. 1978 LOBSTER, AMERICAN 8677 ####### 19. 1305 ######### 33.8784 1979 LOBSTER, AMERICAN 10040 ####### 22.1332 #########+ 39.9006 1980 LOBSTER, AMERICAN e.) create the Column chart using the table from part d. 9973 ####### 21.9869 $41,729,114 41. 7291 1981 LOBSTER, AMERICAN 10266 ####### 22.6316 ########## 47.2369 Axis labels and the title should be chosen from the following list: 1982 LOBSTER. AMERICAN 10310 ####### 22.7303 ######### 50.3436 1983 LOBSTER, AMERICAN 3. Frequency 9968 ####### 21.9766 $51,234,291 51.2343 b. Millions of Pounds 1984 LOBSTER, AMERICAN 8866 ####### 19.5457 ########## 49.2981 e . ) c. Annual Maine Lobster Landings by Pounds 1985 LOBSTER, AMERICAN 9129 ###### 20. 1252 ######### 45.0356 1986 LOBSTER, AMERICAN 8938 ####### 19. 7043 $46,171,224 46. 1712 1987 LOBSTER, AMERICAN 8957 ####### 9.7478 ######### 54.5481 1988 LOBSTER, AMERICAN 9861 ####### 21.7391 ######### 60. 7424 1989 LOBSTER, AMERICAN 10600 ####### 23.3687 $59,552,211 59.5522 1990 LOBSTER, AMERICAN 12732 ####### 28.0682 ######### 61.628 1991 LOBSTER, AMERICAN 13966 ####### 30.7886 ######### 2.2653 1992 LOBSTER. AMERICAN 12170 ####### 26.8304 ########## 71.8227 1993 LOBSTER, AMERICAN 13574 ####### 29.9265 ######### 73.8634 1994 LOBSTER, AMERICAN 17667 ####### 38.9489 ########## 100.9367 1995 LOBSTER, AMERICAN 16877 ####### 37.2083 #########1 101.8932 1996 LOBSTER, AMERICAN 16367 ## #### 36.0834 #### 106.9806 1997 LOBSTER, AMERICAN 21329 ####### 47.0233 ########## 138.2924 1998 LOBSTER, AMERICAN 21336 ####### 17.0368 ##### 137.1893 1999 LOBSTER, AMERICAN 24265 ####### 53.4944 ########## 184.6141 2000 LOBSTER, AMERICAN 25953 ####### 57.2154 #### 187.7148 2001 LOBSTER, AMERICAN 22053 ####### 48.6177 ######### 53.9823 2002 LOBSTER, AMERICAN 28860 3.6257 #### 210.95 2003 LOBSTER, AMERICAN 24934 ####### 54.9709 ######### 205.7153 2004 LOBSTER. AMERICAN 32466 ####### 71.5743 ######### 289.0788 2005 LOBSTER, AMERICAN 31175 ####### 68.7298 ########## 317.9481 2006 LOBSTER, AMERICAN 34155 ####### 5.2983 ######### 307.0362 2007 LOBSTER, AMERICAN 29022 ####### 63.9821 ######### 283.6975 2008 LOBSTER. AMERICAN 31616 ####### 69.7005 ########## 244. 1951 Instructions Questions Ready U - -A1 vi X fx Lobsters B C D E G H K M N O Lobsters m Project Description: In this problem, you will analyze the annual changes in pounds of lobsters. You will also provide the results as a column chart. 6 Steps to Perform: Step Instructions Points Possible 8 Start Excel. Download and open the workbook named: 0 Chapter_1-12_Lobsters_Start 2 In cell 16, calculate the price per pound for lobster in year 1950 using the values in columns F and H. Fill cell 16 down the column to cell 164. Format cells 16:164 as Currency with 2 6 10 decimal places. 11 In cell N16, calculate the average number of lobsters for all years using the values in column E. Format cell N16 as Number with 0 decimal places with commas. 4 IA W 12 In cell N17, calculate the maximum number of lobsters for all years using the values in column E. Format cell N17 as Number with 0 decimal places with commas. 4 13 In cell N18, calculate the minimum number of lobsters for all years using the values in column E. Format cell N18 as Number with 0 decimal places with commas. In cell N19, calculate the range for the number of lobsters for all years. Format cell N19 as Number with 0 decimal places with commas. 4 15 In cell N20, determine the total number of cells with number of lobsters in pounds. Format cell N20 as Number with 0 decimal places with commas 4 16 co In cell N21, calculate the standard deviation using the values in column E. Format cell N21 as Number with 0 decimal places with commas. 4 In cell L26, use the COUNTIF function to calculate the number of cells with lobsters in pounds, which are in the range from 0 to 20,000,000. Fill cell L26 down the column to cell 6 17 L32 and change the criteria in each formula according the value in column K. Format cells L26:L32 as Number with 0 decimal places. 18 10 In cell N26, find the frequency for range from 0 to 20,000,000. Format cell N26 as Number with 0 decimal places. 19 11 In cell N27, calculate the frequency for range from 20,000,000 to 30,000,000. Fill cell N27 down the column to cell N32. Format cells N27:N32 as Number with 0 decimal places. In cell K42:Q57, insert a Clustered Column Chart to illustraite annual maine lobster landings by pounds. Select range M26:N32. On the Insert tab, click Recommended Charts, 12 and then click Clustered Column. Apply Style 7 on the Design tab. Add a chart title and choose the Above Chart option. Replace Chart Title with Annual Maine Lobster Landings by 4 20 Pounds. Add axis titles. Replace Axis Title for the horizontal axis with Millions of Pounds and Axis Title for the vertical axis with Frequency. 13 Save your file and submit for grading. 0 22 Total Points 50 Instructions Questions + Ready p0%