Questions tagged [data-analysis]
12 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
- 3
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
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
- 3
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
- 4
0
votes
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
- 3
- 1
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…
Josh Rawcliffe
- 1
- 1
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
- 3
0
votes
0 answers
Moving (Dynamic) Date Range Filter
I wonder if it is possible in Excel to group entries with some sort of "moving date range".
Similar to the financial analysis moving average.
The idea is to have groups of entries that are each within a range of 3 days.
Assume a list:
1.10 x
2.10…
Fabio Lacchini
- 1
- 1
0
votes
0 answers
Pivot chart to show how percentage scales with size
Is there a good way to visualize this kind of data with an Excel Pivot chart? I imagine as the "size" (column B) increases for the widget, the "percentage of blue" (column C) decreases on average, but I wonder if there's a chart that will help me at…
Dogulas
- 1
- 1
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.
0
votes
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,572
- 18
- 76
- 120