Allen

profileSammy

(Use the following Olympic data for this assignment.)

 

OLYMPICS

 

100 meter free-style Olympic Gold Medal Swimming Records (seconds)

   

Year

Men

Women

1896

82.20

 

1900

62.80

 

1904

73.40

 

1908

65.60

 

1912

63.40

82.20

1920

61.40

73.60

1924

59.00

72.40

1928

58.60

71.00

1932

58.20

66.80

1936

57.60

65.90

1948

57.30

66.30

1952

57.40

66.80

1956

55.40

62.00

1960

55.20

61.20

1964

53.40

59.50

1968

52.20

60.00

1972

51.11

58.59

1976

49.99

55.65

1980

50.40

54.79

1984

49.80

55.92

1988

48.63

54.93

1992

49.02

54.64

1996

48.74

54.50

2000

48.30

53.83

2004

48.17

53.84

2008

47.21

53.12

 

Enter the data above in an Excel spreadsheet, place it on the first worksheet and label the worksheet “OlympicData”. Create two additional worksheets, labeled “PolyTrend” and “ExpTrend”. On each of those worksheets, create an XY chart from the data to illustrate the information graphically. Ensure that your charts are labeled with a title and legends for the x and y-axis. Use three different orders of polynomials in creating trend lines on the “PolyTrend” worksheet. On the “ExpTrend worksheet, create an exponential trend line. Remember to make the information look presentable.

 

Formatting:

 

Text Size: All of the main text in this assignment needs to be set in 10 or 12-point size. Please resist the temptation to mix and match point sizes. If you doubt your applications intentions, just select all of your text and insure that it is in 10 or 12-point size. Your titles, legends and labels can be different sizes.

 

Margins: The right and left side can be set for ½” (0.5) margins. Set the top and bottom margins to one (1”). The only text that ends up on the outside of the one-inch margin is the page number.

 

Name Block: Place the name block in the upper left corner of the page. In MS Excel, use the left side cells. In this class, the name block only needs to be on the first page/first worksheet. Put your name first, then the class title and then the due date.

 

Title: All homework assignments have a title. For all Excel-based assignments, skip one cell and place the title on the left, just below the name block. The title for this assignment is “Homework 2”.

 

Spelling/Grammar Checking: Remember to do your spelling and grammar checking before turning your assignments in. When doing the spelling/grammar checking keep in mind that some words such as mush and must, woods and words, or here and cow, will not be caught by either check. To correct these problems, you will need to proofread your work.

 

Page Numbers: Any homework that has more than one page needs to have page numbers on it. Please place your page numbers on the bottom of the page. In MS Excel, use the footer selection and place the page number in the bottom center or bottom right of the page.

 

Saving/Naming Your File:

 

When you save your file make sure that your name, the class number, and the project number are included in it.

    • 10 years ago
    • 10
    Answer(1)

    Purchase the answer to view it

    blurred-text
    NOT RATED
    • attachment
      yourname403hw2.xlsx
    Bids(1)