Questions tagged [data-analysis]
10 questions
2
votes
2 answers
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 charges with different products per invoice listed as…
devindj6932
- 21
2
votes
1 answer
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 any way to automate this process, where all the…
Arun Kumar
- 21
- 1
1
vote
1 answer
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:Dataset
When I try to have the column with…
Khat
- 13
- 1
- 3
1
vote
1 answer
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
Place A
Indicator 2
5
7
9
Place A
Indicator…
howkesh
- 11
1
vote
1 answer
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[Sales Value]) and slicers for Year…
TheGreatO96
- 15
- 1
- 4
1
vote
2 answers
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 for the Age column, but got a message that the…
ProfK
- 2,741
0
votes
2 answers
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 using a pivot table I'm only able to see the all…
0
votes
1 answer
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 charges with different products per invoice listed as…
devindj6932
- 21
0
votes
2 answers
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 the data collection, and column B is the data…
tori a.
- 1
0
votes
1 answer
#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 the conditional.
