Here are the correlations I need to find in a dataset:
There are 10 power stations in different areas around the city. A city administrator wants to see if there is a correlation between power station location, and the number of days it takes a problem with the power station to be solved.
There are 3 columns:
Station Location
Date problem is identified
Date problem is solved
-There are about 500 entries
Which concept/forumla should be used to find potential correlations? Thank you.
This sounds like a homework assignment?
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
I would add a column =Date solved - Date identified
and then I would use a pivot table, with station location as the row and new column as data. Set to data to look at Average, or even Min or Max to get some ideas.
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Thanks Chemist.
Just to confirm, with the new column, is that just the title of the column or am I entering a formula and dragging down to apply to all?
That would be a formula to drag down, assuming there are dates in B and C
=C2-B2 and format the cells to "General"
So...IS this a homework assignment??
FDibbins, no it's not. Just looking for some additional skills. Thanks for your concern.
Thanks for the feedback
The concepts associated with a question like this would, first, be statistical in nature -- not necessarily related to spreadsheets or Excel. If you are uncertain of the statistical concepts needed for understanding and programming a solution to a problem like this, I would suggest you first start with a statistics text or tutorial.
Some possible refernces:
http://www.real-statistics.com/correlation/
https://en.wikipedia.org/wiki/Correl...and_dependence
http://sphweb.bumc.bu.edu/otlt/MPH-M...variable5.html
or put "introduction to correlation statistics" or similar into your favorite internet search engine.
Once you understand the statistical concepts involved, you can begin to program those formulas into Excel. You will probably want to review the built in statistical functions: https://support.office.com/en-us/art...__toc309306716 to see if your desired test statistic is pre-programmed into Excel.
Originally Posted by shg
Thanks MrShorty, yes, those are definitely good resources. For the purposes of this discussion I think the pivot table is the best option.
Thanks all! There were definitely some huge discrepancies. Here's the distribution for number of days each power station problem took to fix based on community location:
#1 126.9
#2 113.9
#3 84.3
#4 117.8
#5 67.6
#6 50.4
#7 82.0
#8 138.0
#9 84.1
#10 76.9
#11 179.3
#12 64.5
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks