SophiaPretty

(5)

$14/per page/Negotiable

About SophiaPretty

Levels Tought:
Elementary,Middle School,High School,College,University,PHD

Expertise:
Accounting,Algebra See all
Accounting,Algebra,Applied Sciences,Architecture and Design,Art & Design,Biology,Business & Finance,Calculus,Chemistry,Communications,Computer Science,Economics,Engineering,English,Environmental science,Essay writing Hide all
Teaching Since: Jul 2017
Last Sign in: 211 Weeks Ago, 6 Days Ago
Questions Answered: 15833
Tutorials Posted: 15827

Education

  • MBA,PHD, Juris Doctor
    Strayer,Devery,Harvard University
    Mar-1995 - Mar-2002

Experience

  • Manager Planning
    WalMart
    Mar-2001 - Feb-2009

Category > Computer Science Posted 14 Nov 2017 My Price 10.00

analyze the effectiveness of carbon hardening additives

Excel 2016 help don't understand it at all. Need help with assignment.

  • Indy Car

    You have been hired to analyze the effectiveness of carbon hardening additives to Indy car tires. The added carbon increases the puncture strength and you will analyze its impact on burn temperature and weight. You will use Excel's statistical functions and the Analysis ToolPak to complete the next steps. Refer to Figure 8.29 as you complete this exercise.

    Indy Car Experimental

                  8578                              12

                                                      16

                  8790                              18

    20

    24

                  9656                             28

    13                                              1975             29

    14                                              30

    15                                              31

     

    Tires

     

    aso

    535

    673

    910

    1025

    1100

    1250

    1410

    1475

    14.m

    14.25

    15.m

    15.25

    17.m

    27.35

    E.75

    21.00

    0.983171401

    >1400

    Burn Temp

    Puncture Strength

    Bum Temp

    118177.1875

    1520.76875

    Puncture Strength

    22.1270b

    8m frequencyJmubtive %

    10

    5     25.00%

    6     55.00%

    6 85.00% 3 100.00%

    o m.00%

    Histogram

    150WY

    100ms 50OCN

    000%

    Frequencv

    —.—CumulatVe %

     

     
     

    FIGURE 8.29 Indy car Tire Analysis

    a.    Open e08p21ndyCar and save it as e08p21ndyCar_LastFirst.

    b.   Click cell H4 in the Tires worksheet. Type =CORREL and press Tab. Select the range C4:C23 for the first argument, press comma, and then select the range E4:E23 for the second argument. Press CTRL+Enter.

    c.    Click cell 14. Type =STDEV.S and press Tab. Select the range E4:E23 and press Ctrl+Enter.

    d.   Select the range Il 0:116. Type =FREQUENCY and press Tab. Select the range E4:E23 and press comma. Select the range H 10:1115 and press Ctrl+Shift+Enter.

    e.    Load the Analysis ToolPak by completing the following steps, or if it is already available, skip to Step f.

    *   Click the File tab.

    *   Click Options and select Add-ins on the left side of the Excel Options dialog box.

    *   Select Excel Add-ins in the Manage box and click Go.

    *   Click Analysis ToolPak in the Add-ins window and click OK,

    f.     Click the Data tab and click Data Analysis in the Analysis group. Select Histogram. click OK, and then complete the following steps:

    *   Type D4:D23 in the Input Range box.

    *   Type Kl O:KI 5 in the Bin Range box.

    Type M3 in the Output Range box.

    *   Click the Cumulative Percentage option.

    *   Click chart.

    *   Click OK.

    *   Position the chart so the upper-left corner starts in cell M 12 and resize it so the chart fills the range M12:R20.

    g.    Click the Data tab and click Data Analysis in the Analysis group. Select Covariance, click OK, and then complete the following steps:

    Type E3:F23 in the Input Range box.

    Click Columns.

    Click Labels in first row.

    Type HI 9 in the Output Range box.

    Click OK.

    Resize columns H:J and M:O as needed.

    h.   Click the Test Drive worksheet. Click the Data tab and click Data Analysis in the Analysis group. Select ANOVA: Single Factor, click OK, and then complete the following steps:

     

     
     

    TypeC2:E21 in the Input Range box.

    Click Columns.

    Click Labels in first row.

    Type G2 in the Output Range box.

    Click OK.

    Resize Columns G:M as needed.

    i.     Select the range B2:C21, click Data tab, click Forecast Sheet. and click Create.

    j.     Rename the newly created worksheet Forecast and resize the chart as needed.

    k.   Create a footer on all worksheets with your name on the left side. the sheet name code in the center. and the file name code on the right side.

    I. Save and close the workbook. Based on your instructor's directions, submit e()8p21ndyCar_LastFirst.           

Attachments:

Answers

SophiaPretty
(5)
Status NEW Posted 14 Nov 2017 03:11 PM My Price 10.00

-----------  ----------- H-----------ell-----------o S-----------ir/-----------Mad-----------am ----------- Th-----------ank----------- yo-----------u f-----------or -----------you-----------r i-----------nte-----------res-----------t a-----------nd -----------buy-----------ing----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n. -----------Ple-----------ase----------- pi-----------ng -----------me -----------on -----------cha-----------t I----------- am----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I w-----------ill----------- be----------- qu-----------ick-----------ly

Not Rated(0)