# Questions tagged [data-analysis]

The data-analysis tag has no usage guidance.

10
questions

0
votes

1
answer

811
views

### Excel combo chart changing cluster columns into stacked

I am trying to create a combo chart with cluster columns and a line with a 7-day rolling average. One of the clustered columns is in percentages, the other is in whole numbers.
Here is the data set:...

0
votes

2
answers

28
views

### Excel - Total Count of multiple reasons

Ideally, I am looking for a solution where I can see the total number of reasons why the device failed, which is currently recorded in a dropdown list on excel (with option for multiple entries). When ...

2
votes

2
answers

49
views

### What type of dataset am I working with here in Excel? What word or term can best describe it?

I am beginning to delve into data analysis via Excel and I would like to learn more about the terminology in terms of some data I'm playing with.
I've created a sample data set for mock invoice ...

0
votes

1
answer

27
views

### EXCEL: What type of dataset am I working with overall? How to manipulate pivot tables to answer complex relationships between fields?

I am beginning to delve into data analysis via excel and I would like to learn more about the terminology in terms of some data I'm playing with.
I've created a sample data set for mock invoice ...

1
vote

1
answer

85
views

### Calculating correlations on a variable across different locations [Panel/longitudinal data]

Hello I am trying to find the correlations between variables in excel.
My data is structured as follows across different sheets,
Location
Variable
Year 1
Year 2
Year 3
Place A
Indicator 1
1
2
3
...

1
vote

1
answer

2k
views

### Sum of previous year Power BI

I'm working in Power BI with data in the following format:
Year Number
Week Number
Sales Value
1
1
20
1
1
15
2
5
32
...ect
...ect
...ect
I'm currently using the measure Total Sales = SUM(Table[...

0
votes

2
answers

608
views

### How to Fill One Cell With Date Based On Corresponding Cell

For a project, I'd like to look through a set of cells for a maximum in one cell, and auto-populate the next cell based on the corresponding date for the maximum.
For example, column A is the date of ...

0
votes

1
answer

146
views

### #VALUE! error using excel 2016 nested IF statements

I'm unable to perform a simple nested IF statement on this data, the conditional seems perfect to me so it must be a formatting error or something else. I'm new to excel so I could be wrong.
This is ...

2
votes

1
answer

161
views

### I want to combine multiple Excel files

I need assistance with the issue that I have multiple Excel files which are being updated on daily basis but for the analysis part I have to combine them all; and then perform the analysis.
Is there ...

0
votes

2
answers

18k
views

### Why does this Excel column contain non-numeric data?

I have an Excel column that had a list of ages, with several empty cells more or less evenly distributed along the column. I tried to use the Data Analysis Toolkit add-in to get Descriptive Statistics ...