excel chapter 8 terms

studied byStudied by 22 people
5.0(1)
learn
LearnA personalized and smart learning plan
exam
Practice TestTake a test on your terms and definitions
spaced repetition
Spaced RepetitionScientifically backed study method
heart puzzle
Matching GameHow quick can you match all your cards?
flashcards
FlashcardsStudy terms and definitions

1 / 20

flashcard set

Earn XP

Description and Tags

21 Terms

1

Analysis ToolPak

An add-in program that contains tools for performing complex statistical analysis, such as ANOVA, correlation, and histogram.

New cards
2

ANOVA

Stands for Analysis of Variance and is a statistical tool that compares the means between two data samples to determine if they were derived from the same population.

New cards
3

Bins

Data ranges in which values can be categorized and counted.

New cards
4

CORREL function

A statistical function that determines the strength of a relationship between two variables.

New cards
5

Forecast Sheet

A business intelligence feature that creates a forecast worksheet to detail trends based on historical data.

New cards
6

FORECAST.LINEAR function

A statistical function that calculates, or predicts, a future value along a linear trend by using existing values.

New cards
7

FREQUENCY function

A statistical function that determines the number of occurrences of numeric values in a dataset based on predetermined bins.

New cards
8

Histogram

A chart that is similar to a column chart. The category axis shows bin ranges (intervals) where data are aggregated into bins, and the vertical axis shows frequencies.

New cards
9

INTERCEPT function

A statistical function that calculates the point at which a line will intersect the y-axis by using a best-fit regression line plotted through the known x-values and y-values.

New cards
10

LARGE function

A statistical function that returns the kth largest value in a data set.

New cards
11

Population

A dataset that contains all the information you want to evaluate.

New cards
12

Quartile

A value used to divide a range of numbers into four equal groups.

New cards
13

RSQ function

Short for R-square, the RSQ function is a statistical function that returns the square of the Pearson product moment correlation coefficient through the given data points.

New cards
14

Sample

A smaller portion of the population that is easier to evaluate.

New cards
15

SLOPE function

A statistical function that returns the slope of the linear regression line through the given data points.

New cards
16

SMALL function

A statistical function that returns the kth smallest value in a dataset.

New cards
17

Standard deviation

A statistic that measures how far the data sample is spread around the mean.

New cards
18

Standard Error

The level of accuracy of the forecast.

New cards
19

STEYX function

A statistical function that returns the standard error of the predicted y-value for each x in a regression.

New cards
20

Trendline

a visualization that shows patterns in your data.

New cards
21

Variance

A measure of a dataset's dispersion, such as the difference between the highest and lowest points in the data.

New cards

Explore top notes

note Note
studied byStudied by 3 people
677 days ago
5.0(1)
note Note
studied byStudied by 9 people
877 days ago
5.0(1)
note Note
studied byStudied by 304 people
270 days ago
5.0(1)
note Note
studied byStudied by 2 people
13 days ago
5.0(1)
note Note
studied byStudied by 40 people
748 days ago
5.0(3)
note Note
studied byStudied by 4 people
738 days ago
5.0(1)
note Note
studied byStudied by 136 people
670 days ago
5.0(4)
note Note
studied byStudied by 671 people
269 days ago
5.0(2)

Explore top flashcards

flashcards Flashcard (24)
studied byStudied by 6 people
178 days ago
5.0(1)
flashcards Flashcard (29)
studied byStudied by 7 people
710 days ago
5.0(1)
flashcards Flashcard (119)
studied byStudied by 12 people
329 days ago
4.0(1)
flashcards Flashcard (39)
studied byStudied by 5 people
801 days ago
5.0(1)
flashcards Flashcard (35)
studied byStudied by 5 people
40 days ago
4.0(1)
flashcards Flashcard (64)
studied byStudied by 17 people
423 days ago
5.0(1)
flashcards Flashcard (98)
studied byStudied by 5 people
182 days ago
5.0(1)
flashcards Flashcard (52)
studied byStudied by 4536 people
669 days ago
4.4(38)
robot