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:...
- 3
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 ...
- 21
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 ...
- 21
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
...
- 11
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[...
- 15
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 ...
- 1
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 ...
- 21
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 ...
- 2,582