analysis

I am using the statistics functions on Excel 2016, which have various items listed as 'compatibility functions', for instance, =mode and =stdev. I wanted to know, if I import an old spreadsheet: 1) Is there somewhere I can find out which of the new functions the deprecated ones refer to? For...

Hey all, Firstly, thanks for taking the time to read my query. I have the below formula, I am getting an #N/A error despite the data being present. I think I have narrowed the error down to the cells and the fact there are text and numbers in the same cell stored as text.* formula looks...

Hello! I have a massive list of addresses, and I'm looking to pull the state (and the state alone) out of it, and into a separate column. Here's a few rows as an example (not real addresses, to protect identities): <tbody> 2000 ARLINGTON OAKS DR S; MOBILE Alabama 36695-8739 978 VIRGINIA ST...

I have a Risk Analysis spreadsheet. User registers a Risk, the number of the analysis, analysis date, risk probability, risk impact, days for next analysis. For the sake of clarity, lets not even consider the risk probability and risk impact. So you have like <tbody> DATE RISK NAME #...

Hello, When I calculate the standard deviation for a set of numbers, I get a different amount then when I use the "Data Analysis" on the data tab. Why is that? For instance, when I calculate the SD for 1, 2, 3, 4, 5, 6 I get 1.707825 but the data analysis gives me 1.870828. This is...

Hi everyone, I am trying to create a dynamic XIRR formula as I am working on a case study that involves a sensitivity analysis to see changes exit years. How could I go about writing an XIRR formula that ignores 0's while still calculating the correct XIRR? Below is a cut out from my file. There...

I have worksheets of data in the same format (different data / same format) - I am needing to routinely needing to perform a regression analysis on this data. A recorded macro (shortcut key) would be very helpful. I have attempted and continue to strike out to record a macro that: goes to data...

Hello I am aware you can perform certain analysis on your Inbox but is it possible to capture information on for example how long it takes to write or read email I assume Outlook stores somewhere information when email was first created and then sent, the difference between those two would...

Hi MrExcel Am scratching my head on how to "further restrict for exactness" the numbers in my data analysis, for which have been using Joe4's formula as: =IF(ABS(ROUND(A1,0)- A1)<=0.01,"KEEP","DUMP"). I need to go a step further as follows: Lock out any number THAT IS NOT FOLLOWED BY 00 AFTER...

Need help with the formula =COUNTIF(C12:H23,1)+COUNTIF(C12:H23,2) Where C13:H23 = Named Range Week_1 I already know indirect has its drawbacks im just doing some quick and dirty analysis. Thanks for the help

Hello there, I want to make an office Excel data analysis template And make the source outside file.." Week Sales" Like make button * Upload Sales* 1. Week sales ^^^^^ Need I- Auto Recalculate and analysis Template to show results. * Hope i can connect it automaticaly with no needs to...

Hello guys, I have a repetitive analysis which I have to do every day. I am getting one excel per day, and I have to it's data in the analysis. I am sure that it is possible to automatize this process, to make one pattern, and based on that, to import other excels as well. I can make sure...

hi everyone! I would much appreciate if you could help. I want to make a sensitivity analysis for revenue which is dependable on two input factors which are time series, i.e. the price for the unit of my output and the price for the unit of raw material, and both inputs vary from period to...

Hi, I have made an excel file where i want to do a few sensitivity analysis. To remain flexible, i have put a formula on the data that the what if analysis tool has to take for its calculations. https://imagebin.ca/v/3irbzK2IVH6D Like putting on a row -5% to +5% compared to my basic assumption...

Hello, I want to use scenario manager for my calculations but i have too many scenarios(around 1000) with 4 variables. It takes time to write scenarios manually. Besides i may change the scenarios over time. Is there a way to upload scenarios from excel spreadsheet? Or is there another way to...

Hi Forum Hope all is well. I have a quick question concerning Gamification. I am looking for a bit more of an innovative approach to communicating between different groups, and I have been doing a bit of reading and research regarding Gamification. Does anyone know of some sample macros...

Hi, My goal is to create a macro where it updates my data analysis, such as descriptive analysis, histogram, correlation etc. I've managed to record a macro to do this. The problem is that i will update my data, add more rows to it, thus the ranges withing the data analysis (histogram..) will...

Good morning, I have a sheet that has pivot charts connected to an analysis tab. The analysis tab converts qualitative data (<10) to numbers which are then charted on a Log-10 scale. Every time I refresh or use the Timeline slicer, the "Negative or Zero Values Cannot Be Plotted on a Logarithmic...

Below is an inter-company analysis I am working on. It shows that the books of Company A has a $10 receivable from Company B. However, on Company B books, there is a payable to Company A in the amount of $9. I need to include an analysis showing A receivable compared to B payable, and then...

Hi there, Hoping one of you geniuses can help me out here. What I need to find is "x" in the equation: .1 = [b + (x*c)]/[a+x] where "a", "b" & "c" are all numbers based on other formulas that happen in the sheet, so they are always changing but fixed at the time of finding "x". To put that...