# Tagged Questions

**2**

votes

**1**answer

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

**1**answer

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

**0**answers

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

**1**answer

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

**1**answer

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

**2**answers

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

**2**answers

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

**1**answer

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 ...