Question

In: Computer Science

For the following exercises, enter the data from each table into MS-Excel and graph the resulting...

For the following exercises, enter the data from each table into MS-Excel and graph the resulting scatter plots (Use a smoothing function). Determine whether the data from the table could represent a function that is linear, exponential, or logarithmic.

n

1.25

2.25

3.56

4.2

5.65

6.75

7.25

8.6

9.25

10.5

f (n)

5.75

8.75

12.68

14.6

18.95

22.25

23.75

27.8

29.75

33.5

x

1

2

3

4

5

6

7

8

9

10

f (x)

2

4.079

5.296

6.159

6.828

7.375

7.838

8.238

8.592

8.908

m 0

1

2 3 4 5 6 7 8 10
F(m) 10 12 14 16 18 20 22 24 26

28

y

1

2

3

4

5

6

7

8

9

10

f (y)

2.4

2.88

3.456

4.147

4.977

5.972

7.166

8.6

10.32

12.383

z

4

5

6

7

8

9

10

11

12

13

f (z)

9.429

9.972

10.415

10.79

11.115

11.401

11.657

11.889

12.101

12.295

Solutions

Expert Solution

1.) Logarithmic

2.) Logarithmic

3) Linear

4.)Exponential

5.)Logarithmic


Related Solutions

Enter the data from the table below into Microsoft Excel and determine the linear correlation coefficient,...
Enter the data from the table below into Microsoft Excel and determine the linear correlation coefficient, R2 for time versus position. Then, calculate y/t and determine the linear correlation coefficient, R2 for time versus y/t. Write in the calculated values in the table below (use two decimal places). Time, t (s) Position, y (cm) Velocity, y/t (cm/s) 0/60 0.00 1/60 2.41 2/60 5.09 3/60 8.08 4/60 11.30 5/60 14.79 6/60 18.56 7/60 22.52 8/60 26.96 9/60 31.56 Determine the linear...
For the following exercises, use the table of values that represent points on the graph of a quadratic function. By determining..
For the following exercises, use the table of values that represent points on the graph of a quadratic function. By determining the vertex and axis of symmetry, find the general form of the equation of the quadratic function.
Enter the Shoe Size and Height data from the In class data Excel file (use the...
Enter the Shoe Size and Height data from the In class data Excel file (use the excel in class data lab file loaded into the files section of Canvas) into the week 7 Regression Excel sheet. Create a scatter plot for the data, store and graph the regression equation, and note the r2 and r value. Looking at the graph and the r, and r^2 value, do you feel that shoe size is a good predictor for height? Explain your...
Use MS Excel to answer this. From the data given below test a hypothesis for variances...
Use MS Excel to answer this. From the data given below test a hypothesis for variances being equal. Use α = 0.05. Section A Section B 15 16 26 52 52 55 53 57.5 54 58 56.5 60 61 61 61.5 70 63 70 66 71 66 72 66.5 73 69 74.5 71 75 77 75.5 77 76 78 77 79 81 81 85 86 85.5 87 86 90 88 90 88.5 91 91 91 93 94 95 96 98...
Use Excel to graph the following data sets (these graphsdo not need to be adjustable)...
Use Excel to graph the following data sets (these graphs do not need to be adjustable) and then find the equation of the linear regression line and its R2 Value. Use the equation to answer any questions.A. The data shows the results of a study that compared the daily average number of cigarettes an individual smoked per day to his or her death.Daily average # of cigarettes12152230353842465560Average age at death75726966646261585651If a person smokes no cigarettes, what is the expected age...
How do you create a graph in excel from t-test data?
How do you create a graph in excel from t-test data?
Consider the following three market price data. (a) Enter the following sales data using Excel. sales...
Consider the following three market price data. (a) Enter the following sales data using Excel. sales = x1 sales = x2 sales = x3 Price A ($) 10 10 10 100 10 10 13 99 10 10 15 98 12 10 10 98 12 12 10 97 12 14 10 95 14 10 10 94 (b) Use LINEST to find a linear price function for the above data for three markets. (Note: You will be using the format (Price =...
For the following exercises, each graph is a transformation of y = 2x. Write an equation describing the transformation.
For the following exercises, each graph is a transformation of y = 2x. Write an equation describing the transformation. 
For the following exercises, graph the inequality. y > x2 − 1
For the following exercises, graph the inequality. y > x2 − 1
The following table gives the bushels of corn per acre, y resulting from the use of...
The following table gives the bushels of corn per acre, y resulting from the use of the various amounts of fertilizer in pounds per acre, x, produced on a farm in each of 10 years from 1971 to 1980.   Year n y x 1971 1 40 6 1972 2 44 10 1973 3 46 12 1974 4 48 14 1975 5 52 16 1976 6 58 18 1977 7 60 22 1978 8 68 24 1979 9 74 26 1980...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT