Excel Yogi's - Group: Crystal Xcelsius and Excel Users

susanbell84 on 3 Free Dissertation Titles on your subject!!!

Tue, 14 Jul 2009 20:53:28 -0700

I am doing my MBA from Ireland in international business. I have worked with construction industry for couple of years including a stint in gulf area and I needed to submit my dissertation this semester. I have a special interest in business development and wanted some suggestions for dissertations titles specifically focusing the Ireland industry. I was browsing through the website when I found this dissertation help website providing dissertation writing help. I didn’t know that they also offer help with dissertation writing along with FREE dissertation topic. Anyway, here is the list of good dissertation title they sent me after my request:

1. The economic impact, the Ireland health care business creates by hiring nurses from second world countries to help provide relief to the current nursing shortage here.

2. Business and Financial Analysis of a domestic business in Ireland expanding towards International Trade.

3. Impact of IT development in FMCG sector.

My supervisor really liked the first topic and now I am writing a dissertation on it. The free dissertation titles service really helped me in getting off with my dissertation writing quickly. I would like to know other people’s experiences on that…

Joseph Harris on Xcelsius Tabs

Tue, 03 Feb 2009 15:55:31 -0700

I believe tabs were introduced in 2008, although, you can mimic tabs using backgrounds and the label based menu object.

Joe

Excelbuggy on Xcelsius Tabs

Tue, 03 Feb 2009 14:47:26 -0700

Anyone know which version of Xcelsius has "tabs"?

oscpyra on This will come in handy

Tue, 03 Feb 2009 10:48:02 -0700

I like this site...I started as an Analyst I at GE yesterday. I think I will be spending a lot of time here. Let me know if you need a moderator.

oscpyra on Correlation Coefficient in Excel

Tue, 03 Feb 2009 10:15:56 -0700

correl() is often misunderstood but can be very powerful. I use it almost daily as a business analyst. It is hard to beat for quick, two variable, correlation.

The problem (as Joe points out in the original post) is that people confuse correlation with causation.

Joseph Harris on Correlation Coefficient in Excel

Tue, 03 Feb 2009 10:05:30 -0700

The Correl() function and its use has become one of the most hotly debated, researched and talked about on Excelyogi. I thought this would be a good first "discussion starter" in the new forum.

Joe

Joseph Harris on Correlation Coefficient in Excel

Tue, 03 Feb 2009 09:59:56 -0700

Q: Hi, I need to be able to tell if two variable are related/correlated. How can I do this in Excel? Thanks, Jalelle A: Jalelle, You are in luck, there is a simple built in function in Excel called correl(). Correl() is the Excel function for the correlation coefficient. The correlation coefficient measures the strength and direction of the relationship between two variables. So, if you have two rows of data, lets say sales in row 1 and customers in row 2, you can use the correl() function to tell if they are related. The format would be correl(a1:z1, b2:z2). Sales and customers (any two variables) could be correlated in two ways. The first way is negative correlation. Negative correlation tells you when one variable goes up, the other will go down. The second type of correlation is positive correlation. Positive correlation tells you that as one variable goes up, the other variable will go up as well. When you use the correl() function it will return a positive or negative number. The plus and minus indicates the positive or negative relationship and the size of the number indicates the strength of the relationship. The table below helps to explain what the correl() number means for your data set.

Correlation	Negative	Positive
Small	−0.3 to −0.1	0.1 to 0.3
Medium	−0.5 to −0.3	0.3 to 0.5
Large	−1.0 to −0.5	0.5 to 1.0

Joseph Harris ExcelYogi.com