2
votes
1answer
97 views

How to format numbers in Excel column using the same exponent?

I have a bunch of decimal numbers in a particular column, for example: 1.123E-05 4.567E-06 8.910E-03 1.112E-07 I would like to format the column so that they have a common exponent, say E-06 like ...
0
votes
1answer
31 views

Excel Statistical Table

I am trying to create a statistical table based on columns of information. The row/column identifiers of the table are also incorporated in part of the statistics of the table. I have three columns of ...
1
vote
0answers
104 views

Best approach to doing automatic analysis of sets of tags in Excel/Access/or similar?

I have a large set of open-ended responses to a survey (~10,000), and each has been assigned a set of tags representing what the person has said in the response. This data is sitting in an Excel ...
2
votes
1answer
544 views

Excel 2010 not displaying calculated measures as currency

When connecting Excel 2010 to a SSAS 2008 R2 datasource, calculated fields(Standard Margin) do not display with the appropriate currency symbol. When I define the measures in the cube, I am setting ...
2
votes
1answer
346 views

Can I do a Multiple Regression with Excel?

I have performance data for 3 years for about 50K employees. Each employee has 3 ratings associated with them. I would like to create an equation that will predict (or try to predict) the future ...
1
vote
2answers
311 views

Desktop software for data analysis, like Business Objects “Lite”

My data set is sourced from ~100k users, with a few million records scattered over a dozen tables. Just too big for Excel, but not quite a data warehouse. It's sourced from a web-sites user base and ...
2
votes
2answers
886 views

Excel Free Text Survey Analysis

I have to analyze a survey. The survey consists of some yes/no questions, some numeric questions and some questions like the following (free text where respondents have entered multiple answers). Do ...
1
vote
1answer
311 views

Excel price function not working despite adding the analysis tool pack

I am trying to price bonds using the Excel function, PRICE(..), but the intellisense doesn't come up. The help file says to install the analysis tool pack, but this doesn't resolve the problem. I have ...