Question

How do you create a data table in excel using full data range in the data...

How do you create a data table in excel using full data range in the data worksheet?

Homework Answers

Answer #1

answer:-

create a blank workbook or worksheet ; select the example in help topic ; press CTRL+C ; in the worksheet , select cell A1, and press CTRL+V ; press formulas tab in the formula auditing.

- Select all cells in the range expect cells A1 and A2.

- Click the DATA tab ,click what if analysis , and then click DATA TABLE.

- In the row input cell box, enter A1 , in the column input cell box , enter A2 , and then click OK.

- Optionally , you can freeze the data table by converting the result to their values.

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
how do you change data in a chart to a percentage using excel
how do you change data in a chart to a percentage using excel
How do I create a table showing pairwise correlations of three variables in excel? Sample Data...
How do I create a table showing pairwise correlations of three variables in excel? Sample Data 99.81 109.3949 104.6233 103.73 102.6855 104.2667 101.95 103.4166 105.72 116.36 102.39 101.83 104.19 112.169 107.3467 109.37 106.5837 107.5 110.23 108.5341 109.9733 122.73 109.7212 107.93
Be sure to do your computations using Excel. Do not do computations using Table A, Table...
Be sure to do your computations using Excel. Do not do computations using Table A, Table C, or on a calculator and then type the answers into Excel. 1. Researchers did a study to compare how much men and women talk because it is commonly thought that women talk more then men. The study collected data from a simple random sample of women and a simple random sample of men. For each individual in these samples the researchers gave the...
Calculate the confidence intervals (CI) at 95% and 99% using Excel for the following data on...
Calculate the confidence intervals (CI) at 95% and 99% using Excel for the following data on shoes: 12, 14,11,12,21,18,11,18,25,30,23,32,15,22,15,25,27,33,30,30,25 (Calculate the full range).
Create a frequency table and a histogram for each of the data sets from Part 2....
Create a frequency table and a histogram for each of the data sets from Part 2. Below are two links explaining how to use Excel to create frequency tables and histrograms. Using Excel for Data and Tables Create a Histogram From a Frequency Table 1) Data Set 1: 23, 26, 50, 39, 55, 64, 50, 10, 42, 35, 51, 42, 43, 56, 64, 48, 48, 57, 27, 37 a. List the data values in order from lowest to highest. b....
Using the data from question 1, create a frequency table and a histogram in Microsoft® Excel®....
Using the data from question 1, create a frequency table and a histogram in Microsoft® Excel®. QUESTION 1 DATA- enter the following data from the 40 participants by first creating a variable labeled “Score”. Next, compute the mean, median, and mode for the following set of 40 reading scores: 31 32 43 42 24 34 25 44 23 43 24 36 25 41 23 28 14 21 24 17 25 23 44 21 13 26 23 32 12 26 14...
Can you show me how to do this using Excel? Suppose we gathered the data below...
Can you show me how to do this using Excel? Suppose we gathered the data below by an unbiased method.  (The data is sorted DOWN the columns.) 111 116 119 120 123 126 128 131 136 142 115 117 119 120 123 127 129 132 136 142 115 117 120 121 123 127 129 133 138 143 115 118 120 121 123 128 131 133 138 158 116 118 120 123 125 128 131 135 141 163 (4 pts) Use the...
(EXCEL VBA)Create a new worksheet and name it as “Roster”.You have the class roster in the...
(EXCEL VBA)Create a new worksheet and name it as “Roster”.You have the class roster in the worksheet “Roster” and the full names of students are in column A, starting in Cell A3, with last name last and case insensitive (such as Ben ALT). Write a sub that counts the number of names in the list with last name ALT and then displays this count in an MsgBox that is titled “Number of ALTs” and has an Exclamation icon button. Note...
using the data table process in excel, design and develop a compound interest data table using...
using the data table process in excel, design and develop a compound interest data table using the following information. A) The two (2) variables to be manipulated are: [1) the dollar amount invested (100-500 in increments of 100), 2) the number of years invested (2-10 in increments of 2)]; B) the constant, annual interest rate is to be 4.25%; C) Round the formula for computing compound interest to 2 decimals using the following compounding formula: the dollar amount invested multiplied...
please show me how to do this using excel you do not expect there to be...
please show me how to do this using excel you do not expect there to be a dividend paid on a share of common stock next year. after that you expect a $2 dividend that will grow at a constant rate of 6% there after. how much would you pay for the stock assuming a cost of equity of 10%