# statistical

1. ### Typing Statistical Symbols like X̅ in Excel

How to a write statistical symbols like X-bar, X̅, in Excel. I also want to write Y-bar and d-bar. I am using Excel 16.29 on a Mac. eddiev10025
2. ### Set of amounts that sums to zero

<tbody> ID_SPAR ID_ITOR AMOUNT DESIRED OUTPUT 3221876 4448945 -51471.74 Matched 3221876 4448945 -54452.02 Investigate 3221876 4448945 22239.20 Matched 3221876 4448945 29232.54 Matched 3227654 4448974 -28956.90 Matched 3227654 4448974 -25917.90 Investigate 3227654 4448974 28956.90...
3. ### Statistical Tests

Hello. Do you guys have an idea how to do the following tests in MS Excel? 1. Pearson Correlation 2. t-test 3. F-test Thank you in advance.
4. ### Question on running data analysis in Excel

Hi all, I'm a bit new to running data analysis in Excel, have a decent statistical understanding but not with regards to Excel. I figured out how to get the data analysis tools but am having trouble getting my exact setup for my data. The data I'm trying to build off of is this: I want to...
5. ### Statistics Help on Excel

How do you find the statistical difference between a slope of -0.09 and a slope of 0? What steps would you need to do to figure it out? What statistical analysis would you need to do?
6. ### How to Adjust the Axes to Accurately Show Data [Box Plot]

Hello, So, I am trying to create a box plot of a statistical breakdown. My statistical breakdown does have negative values and I was able to make a box plot to account for the negative values by using a first and secondary axis. Right now, my problem is that I am not sure how to adjust the box...
7. ### Applying Excel to Statistics

To whomever is reading this, I have been given a series of questions by my boss in order to try taking statistical problems and using excel functions in order to derive the answers. I am completely new to both the fields of excel and statistics and would like some guidance on how to go about...
8. ### Statistical Prediction

I have a table which has 8 Columns. I have data put in weekly for the last 3 years with the example being below. What i want is a formula that will predict what the next 6 months of data would be in rows ranging from batch 103 onwards. I need a simple formula with cell references that take into...
9. ### Returning Value from Time Ranges

Hi Everyone I have a data table that shows a list of times Trailers were tipped, from which site in time order such as <tbody> Date Despatch Site Time of Trailer Unloaded 28/02/2016 MD01 06:13 28/02/2016 KA09 06:56 28/02/2016 MD19 07:42 </tbody> I then on a separate sheet have a...
10. ### Urgent Help needed

Gurus, i have the below worksheet. what i need help is the statistical selection that for each group there is equal chance of selection of cities based on the Ethnicity. each group need to have diverse selection meaning at least one from each athnicity and when in the last groups when some...

### This Week's Hot Topics

• VBA code giving errors and stopping Excel
Hello Experts, I have this code being used to loop through files in a file path, and copy specific data to another sheet. It is giving me several...
• Disable MsgBox message
Morning, I have a userform where if i leave a ComboBox empty i see a MsgBox warning me that i must enter an invoice number. It is this MsgBox i...
• Macro Recorder into VBA, Copy Paste Data Filled Cells
Hi Everyone, I have a macro recorder file that takes a selection of data, copies, then pastes into a new sheet on ("A2:B2") The issue is my...
• Number format changes while pasting into a cell
Hi, I am trying to paste a number 180204524303 from an email to an excel cell, however, whenever i try to do so , the the paste value appears as...
• Collating data
Hello all. Could someone please help. I am trying to pull all column data from multiple sheets (24 I total so far) into 1 master sheet without...
• Sum Multiple Columns Based on Multiple Criteria
I am trying to consolidate data by summing columns G through M based on material, plant, vendor, and fiscal year being identical. The period does...