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?

Business   Accounting   
0 0
Add a commentTranscribed image text
Next >

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.

0 0
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
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
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
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...
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...
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%
How do you find the 90th percentile of the data from Table 1 in Question #2...
How do you find the 90th percentile of the data from Table 1 in Question #2 using Percentile.INC( ) function in Excel. Table 1: Health Expenditures as a Percentage of GDP of countries around the world 3.35 5.96 10.64 5.24 3.79 5.65 7.66 7.38 5.87 11.15 5.96 4.78 7.75 2.72 9.50 7.69 10.05 11.96 8.18 6.74 5.89 6.20 5.98 8.83 6.78 6.66 9.45 5.41 5.16 8.55
a.) Determine if a' + a'y = a' using a truth table. DO NOT REFER TO...
a.) Determine if a' + a'y = a' using a truth table. DO NOT REFER TO THE FORMULA SHEET. This must be proved via truth table. Use the table tool, to create your truth table. If you are unable to use the table tool, you can use excel or word to create the table and copy paste. Be sure to write a statement indicating that this is true or not. b.) Given that x + 1 = 1 is true....
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT