answersLogoWhite

0


Best Answer

You can assign a numerical value to each element in your data series. There are several ways to do that. Here is a simple example:

  1. In cell A1 enter your first data element. Let that entry be GREEN.
  2. In cell B1 enter the formula, =IF(A1="GREEN",1,0). Observe that the value of B1 is 1, since the contents of cell A1 is GREEN. If A1 = RED, then B1 would display 0.

You also could give a value to each data item depending on the number of characters in the cell. You can do this with the formula =LEN(A1).

User Avatar

Wiki User

14y ago
This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: How do you represent data as a series of numerical values?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

What is a set of numerical data?

In statistics numerical data is quantitative rather than qualitative.


What is the data that is comprised of numerical values?

interval data


What contains the numerical data displayed in a chart?

Y


What type of graph would be best to represent numerical data?

BAR ;)


What is values in a data series?

This question is not clear. My best guess would be to say that the values of a data series are represenations of the individual data items in the series.


When creating a Chart in Excel a multiple date series is?

A data series is a range of values to be charted. If you have multiple data values, you may have multiple series, like several lines on a line chart. So you can have lots of values in a series, and lots of series in some charts. A pie chart cannot have more than one series. Data can be of various types.A data series is a range of values to be charted. If you have multiple data values, you may have multiple series, like several lines on a line chart. So you can have lots of values in a series, and lots of series in some charts. A pie chart cannot have more than one series. Data can be of various types.A data series is a range of values to be charted. If you have multiple data values, you may have multiple series, like several lines on a line chart. So you can have lots of values in a series, and lots of series in some charts. A pie chart cannot have more than one series. Data can be of various types.A data series is a range of values to be charted. If you have multiple data values, you may have multiple series, like several lines on a line chart. So you can have lots of values in a series, and lots of series in some charts. A pie chart cannot have more than one series. Data can be of various types.A data series is a range of values to be charted. If you have multiple data values, you may have multiple series, like several lines on a line chart. So you can have lots of values in a series, and lots of series in some charts. A pie chart cannot have more than one series. Data can be of various types.A data series is a range of values to be charted. If you have multiple data values, you may have multiple series, like several lines on a line chart. So you can have lots of values in a series, and lots of series in some charts. A pie chart cannot have more than one series. Data can be of various types.A data series is a range of values to be charted. If you have multiple data values, you may have multiple series, like several lines on a line chart. So you can have lots of values in a series, and lots of series in some charts. A pie chart cannot have more than one series. Data can be of various types.A data series is a range of values to be charted. If you have multiple data values, you may have multiple series, like several lines on a line chart. So you can have lots of values in a series, and lots of series in some charts. A pie chart cannot have more than one series. Data can be of various types.A data series is a range of values to be charted. If you have multiple data values, you may have multiple series, like several lines on a line chart. So you can have lots of values in a series, and lots of series in some charts. A pie chart cannot have more than one series. Data can be of various types.A data series is a range of values to be charted. If you have multiple data values, you may have multiple series, like several lines on a line chart. So you can have lots of values in a series, and lots of series in some charts. A pie chart cannot have more than one series. Data can be of various types.A data series is a range of values to be charted. If you have multiple data values, you may have multiple series, like several lines on a line chart. So you can have lots of values in a series, and lots of series in some charts. A pie chart cannot have more than one series. Data can be of various types.


Which type of graph displays data with bars that represent numerical amounts?

bar


What is the middle value of a data set when the values are written in numerical order?

Median


What is the middle value when the values are written in numerical order in a data set?

Median


What are numbers text datas or time of day that you type into a cell in Excel called?

Data or values.


What is a measure for a numerical data set summarizes all of its values with a single number?

Center


What is x-bar in statistics?

The numerical average of a set of data is called x-bar. This is the sum of all values divided by the number of values.