The pivot tag has no wiki summary.
1
vote
0answers
31 views
Graph data from an Excel Pivot in a Tree Representation
I've been looking for a while to see if there's any add-on or software which allows data from an excel pivot to be graphed dynamically in a visual tree representation. I know of the likes of graphviz ...
1
vote
0answers
27 views
Does pivoting a discrete CDF provide a pivot?
In Section 9.2.3 of Casella's Statistical Inference,
they base their confidence interval construction for a parameter $\theta$ on a real-valued statistic $T$ with cdf $F_T(t| \theta)$.
They first ...
1
vote
0answers
37 views
Can pivot be used for testing
A pivotal quantity $Q(X, \theta)$ can be used to construct a confidence interval. I was wondering if it can be used to construct a test statistic and rejection region? In simpler cases involving a ...
1
vote
1answer
81 views
pivotal statistic versus distribution free statistic
I was wondering what relations and differences are between pivotal statistic versus distribution free statistic?
From Wikipedia
a pivotal quantity or pivot is a function of observations and ...
3
votes
1answer
46 views
Terminology of two different tabular representations of aggregated data
think of a group of people aged from 21 to 35 years.
Then we can show the number of persons regarding gender and age groups 21-25, 26-30 and 31-35 in (at least) two different ways:
Type A
Type B
...
1
vote
1answer
100 views
How can you summarize growth in the “production” rate per person?
I have been reading the book, Good to Great by Jim Collins. It says that you should focus on information that "cannot be ignored," and that you should focus on the right "denominator."
I thought it ...
0
votes
1answer
448 views
Excel pivot table with multiple total columns
Is there a way in Excel to create a pivot table with multiple column totals?
Here's column names to demonstrate what I'm trying to do:
Jan | Feb | Mar | Apr | May | Jun | 6 Month total | Jul | Aug | ...
0
votes
0answers
45 views
Tracking problem with a formula
I have 4 variables, each of which can take on a value of .01 to .99. I have the following equation:
$$\text{Achievement} = 9 \frac{\text{Facility rate during perf. period} – \text{Achievement ...
2
votes
0answers
148 views
Pivot functions [closed]
I have the following problem:
Suppose we have a sample $Y_1,...,Y_n \sim N(\mu, \sigma^2)$. Find the
pivotal function for $\sigma^2$ when
$\mu$ is known and when $\mu$ is
unknown.
I know ...
1
vote
1answer
1k views
Pivotal quantities, test statistics and hypothesis tests
We are learning pivot functions, test statistics, and hypothesis testing at university but it makes no sense. I've tried reading my text book/notes, going through examples, etc., but the concepts seem ...
