一个好用的EXCEL插件工具_excel做图插件资源-CSDN文库

共283个文件

gif：223个

htm：30个

xla：30个

需积分: 45 136 浏览量 2014-03-24 18:56:04 上传评论 2 收藏 1.82MB ZIP 举报

Excel是一款广泛应用于数据分析和报告编制的强大电子表格软件。在Excel中，VBA（Visual Basic for Applications）是一种内置的编程语言，允许用户自定义功能、创建宏以及自动化工作流程。本压缩包提供了一个实用的Excel插件工具，同时附带了VBA源码，非常适合那些希望学习或提升VBA技能的用户。让我们来了解Excel插件工具。这种工具通常通过扩展Excel的功能来提高工作效率。它们可以提供额外的数据处理选项、分析工具或者图形界面，使得用户在处理大量数据时能更便捷地进行计算、统计和可视化。在本压缩包中，尽管具体插件功能未详述，但我们可以假设它包含了一些实用的宏和自定义函数，可能涉及到数据排序、过滤、图表生成等。 VBA是Microsoft Office套件中的编程环境，它基于VB6语法，用户可以通过编写VBA代码实现Excel的自动化操作。学习VBA有助于用户深入理解Excel的工作原理，定制个人化的工具，甚至创建复杂的商业应用程序。VBA源码对于初学者来说是一个宝贵的资源，通过阅读和理解这些代码，可以加快学习进程，了解如何实现特定功能。压缩包中的文件名多以“Regr”（回归）、“FCast”（预测）、“Transform”（转换）和“Unstack”（展开）开头，这暗示了这些资源可能与统计分析、时间序列预测和数据转换有关。例如： 1. Regr（回归）系列的文件可能包含了关于线性回归或者其他统计模型的示例，这些模型在数据分析中用于探索变量间的关系。 2. FCast（预测）系列的文件则可能涉及时间序列分析，如ARIMA模型，用于预测未来的趋势或周期性变化。 3. Transform（转换）和Unstack（展开）可能涉及数据预处理，如数据的归一化、标准化，或者将分层数据展开为平铺结构，以便于进一步分析。每个.gif文件可能是VBA代码执行过程中的动态图，展示了函数或宏在实际操作中的效果，这对于理解和调试代码非常有帮助。通过打开这些文件，用户可以直观地看到每段代码是如何影响Excel工作表的。这个压缩包提供了一个学习和实践Excel VBA的宝贵平台，不仅可以帮助用户掌握基本的编程技巧，还能深入了解如何利用VBA进行复杂的数据分析和自动化工作。对于数据分析师、财务工作者、学生或任何对Excel高级应用感兴趣的人来说，都是一个值得探索的资源。

资源推荐

资源详情

资源评论

收起资源包目录

一个好用的EXCEL插件工具（283个子文件）

Regr14.gif 18KB

FCast13.gif 16KB

Regr11.gif 16KB

Transform6.gif 16KB

Regr18.gif 14KB

FCast10.gif 14KB

SRegr6.gif 12KB

Regr1.gif 12KB

Unstack1.gif 12KB

FCast7.gif 12KB

Runs5.gif 12KB

Dummy7.gif 12KB

1Way6.gif 11KB

Hist7.gif 11KB

Interact7.gif 11KB

RandSamp3.gif 11KB

UCht6.gif 10KB

PCht5.gif 10KB

Hist6.gif 10KB

XBR2.gif 10KB

Regr7.gif 9KB

Interact4.gif 9KB

CCht4.gif 9KB

XBR1.gif 9KB

2Way6.gif 9KB

Dummy5.gif 9KB

Chi5.gif 9KB

PSamp6.gif 8KB

Lag4.gif 8KB

FCast3.gif 8KB

XBR7.gif 8KB

XBR5.gif 8KB

Hist4.gif 8KB

XBR4.gif 8KB

Dummy1.gif 8KB

Interact1.gif 8KB

TS4.gif 7KB

SS4.gif 7KB

ChiNorm6.gif 7KB

TS5.gif 7KB

2Samp7.gif 7KB

Unstack5.gif 7KB

1Samp4.gif 7KB

AC6.gif 7KB

FCast8.gif 7KB

Hist3.gif 7KB

UCht7.gif 6KB

FCast11.gif 6KB

FCast14.gif 6KB

CCht5.gif 6KB

Stack1.gif 6KB

PCht2.gif 6KB

CC4.gif 6KB

Interact10.gif 6KB

FCast15.gif 6KB

UCht3.gif 6KB

UCht1.gif 5KB

Diff4.gif 5KB

ChiNorm3.gif 5KB

TS3.gif 5KB

PCht9.gif 5KB

BP4.gif 5KB

1Way1.gif 5KB

2Samp1.gif 5KB

ChiNorm5.gif 5KB

Regr9.gif 5KB

FCast9.gif 5KB

PCht7.gif 5KB

2Samp5.gif 5KB

PSamp4.gif 5KB

FCast12.gif 5KB

1Samp5.gif 5KB

TS2.gif 5KB

PCht8.gif 4KB

1Samp2.gif 4KB

Regr19.gif 4KB

Regr4.gif 4KB

SS2.gif 4KB

2Way2.gif 4KB

Unstack4.gif 4KB

Interact9.gif 4KB

Stack6.gif 4KB

Interact6.gif 4KB

SS3.gif 4KB

TS1.gif 4KB

CC3.gif 4KB

FCast6.gif 4KB

2Way4.gif 4KB

Interact3.gif 4KB

Regr6.gif 4KB

1Way5.gif 4KB

PSamp5.gif 4KB

Interact2.gif 4KB

2Samp6.gif 4KB

AC3.gif 4KB

Interact8.gif 4KB

BP1.gif 4KB

1Samp3.gif 4KB

Interact5.gif 4KB

AC4.gif 4KB

共 283 条

<HTML> <HEAD> <META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=windows-1252"> <META NAME="Generator" CONTENT="Microsoft Word 97"> <TITLE>Welcome to the Practical Statistics Add-in</TITLE> <META NAME="Template" CONTENT="C:\PROGRAM FILES\MICROSOFT OFFICE\OFFICE\html.dot"> </HEAD> <BODY LINK="#0000ff" VLINK="#800080"> <H1>Welcome to the StatPro Add-in!</H1> <P>The purpose of the StatPro add-in is to provide you with some powerful statistical capabilities in an environment you're used to-the environment of Excel. StatPro contains a number of procedures, such as creating a scatterplot, testing a variable for normality, and running a regression. Each of these procedures can be run from the StatPro menu that is added to the Excel menubar when you load the add-in. Most of the procedures provide some explanations as you run them. In addition, each gives you the option of reading help screens specific to that procedure. Finally, the help screen you're reading now provides an overall guide to the procedures.</P> <H2>Contents of this Help File</H2> <UL> <LI><A HREF="#Goals">Goals of StatPro</A> </LI> <LI><A HREF="#DataSetup">StatPro dataset requirements: extremely important!!!</A> </LI> <LI><A HREF="#Conventions">StatPro conventions</A> </LI> <UL> <LI><A HREF="#ChartPlacement">Placement of charts</A> </LI> <LI><A HREF="#NumericalPlacement">Placement of numerical output</A> </LI> <LI><A HREF="#VariablePlacement">Placement of new variables</A> </LI> <LI><A HREF="#Missing">Treatment of missing values</A> </LI> <LI><A HREF="#Character">Treatment of character variables</A> </LI> <LI><A HREF="#Formulas">Use of formulas versus values</A> </LI> <LI><A HREF="#NamedRanges">Named ranges and hidden sheets</A> </LI> <LI><A HREF="#Comments">Use of comments in cells</A></LI></UL> <LI><A HREF="#Summary">Summary of procedures</A> </LI> <UL> <LI><A HREF="#SummStats">Summary Stats</A> </LI> <UL> <LI><A HREF="#OneVar">One-variable summary stats</A> </LI> <LI><A HREF="#Corr">Correlation, covariances</A> </LI> <LI><A HREF="#Auto">Autocorrelations</A></LI></UL> <LI><A HREF="#Infer">Statistical inference</A> </LI> <UL> <LI><A HREF="#OneSamp">One-sample analysis</A> </LI> <LI><A HREF="#TwoSamp">Two-sample analysis</A> </LI> <LI><A HREF="#PairSamp">Paired-sample analysis</A> </LI> <LI><A HREF="#SampSize">Sample size selection</A> </LI> <LI><A HREF="#OneWay">One-way ANOVA</A> </LI> <LI><A HREF="#TwoWay">Two-way ANOVA</A> </LI> <LI><A HREF="#ChiSq">Chi-square test for independence</A> </LI> <LI><A HREF="#Runs">Runs test for randomness</A> </LI> <LI><A HREF="#RandSamp">Generating random samples</A></LI></UL> <LI><A HREF="#Normality">Tests for normality</A> </LI> <UL> <LI><A HREF="#ChiNorm">Chi-square test for normality</A> </LI> <LI><A HREF="#Lill">Lilliefors test for normality</A> </LI> <LI><A HREF="#QQ">Q-Q normal plots</A></LI></UL> <LI><A HREF="#Regr">Regression analysis</A> </LI> <UL> <LI><A HREF="#Simp">Simple</A> </LI> <LI><A HREF="#Mult">Multiple</A> </LI> <LI><A HREF="#Step">Stepwise</A> </LI> <LI><A HREF="#Forw">Forward</A> </LI> <LI><A HREF="#Back">Backward</A> </LI> <LI><A HREF="#Block">Block</A></LI></UL> <LI><A HREF="#Forecast">Forecasting</A> </LI> <LI><A HREF="#Quality">Quality control charts</A> </LI> <UL> <LI><A HREF="#XBR">X-Bar, R charts</A> </LI> <LI><A HREF="#PCht">P charts</A> </LI> <LI><A HREF="#CCht">C charts</A> </LI> <LI><A HREF="#UCht">U charts</A></LI></UL> <LI><A HREF="#Utilities">Data utilities</A> </LI> <UL> <LI><A HREF="#Stack">Stack variables</A> </LI> <LI><A HREF="#Unstack">Unstack variables</A> </LI> <LI><A HREF="#Dummy">Create dummy variables</A> </LI> <LI><A HREF="#Interact">Create interaction variables</A> </LI> <LI><A HREF="#Transform">Transform variables</A> </LI> <LI><A HREF="#Lag">Create lagged variables</A> </LI> <LI><A HREF="#Diff">Create difference variables</A></LI></UL> <LI><A HREF="#Charts">Charts</A> </LI> <UL> <LI><A HREF="#Hist">Histograms</A> </LI> <LI><A HREF="#Scat">Scatterplots</A> </LI> <LI><A HREF="#Box">Boxplots</A> </LI> <LI><A HREF="#TSPlot">Time series plots</A></LI></UL> </UL> </UL> <H2><A NAME="Goals"></A>Goals of StatPro</H2> <P>We have kept several goals in mind while developing this add-in. First, we want it to be easy to use. Second, we want it to "look" like Excel-we want you to be comfortable with the interface. Third, we want it to be "natural" for statistical use. Finally, we want it to be a reasonably powerful tool, especially for learning statistics in a course environment.</P> <H2><A NAME="DataSetup"></A>StatPro Dataset Requirements: Extremely Important !!!</H2> <P>We now expand on the third goal. There are a number of other statistical Excel add-ins available, including the Data Analysis ToolPak that ships with Excel. (If you installed it, you'll find it under the Tools menu.) All of the add-ins we've seen are structured around <I>ranges</I>, where you are asked to select one or more ranges. You typically select these by pointing and dragging with your mouse, and it is usually not very convenient. We have taken our cue, however, from non-Excel statistical packages, which are almost all structured around <I>variables</I>. In these packages you typically select a procedure and then select one or more variables to use in that procedure. This is not only an easier interface to work with, but it makes more sense from a statistical point of view.</P> <P>Therefore, we impose some structure on users, much like the structure that is automatically imposed on all users of statistical packages. Except in two instances, we always require that you always work with a "data set," by which we mean a set of contiguous columns that correspond to statistical variables, with variable names in the first row of the data set. You should imagine such a data set as a range that is surrounded by blank rows and columns on all sides (or possibly by the column labels and row labels on the left and the top). In other words, you shouldn't let extraneous stuff bump up next to your data set. This notion of an "isolated" data set range is crucial to the way StatPro works.</P> <P>There are two other notes about the structure of your data sets. First, the variable names in the top row must adhere to Excel's naming rules for ranges. Basically, this means that names should start with a letter, they shouldn't use characters other than letters, numbers, and the underscore (_) character (although we allow spaces and periods), they shouldn't be the single letter R or C, and they shouldn't look like cell addresses (such as X1). Obviously, it's best to use names that are meaningful, such as Revenue or Variable_Cost. Second, the lengths of the columns in your data set do not have to be equal. For example, you could have two variables, Weight_Men and Weight_Women, with different numbers of observations. If this is the case, however, the add-in will treat the blank cells in the shorter columns as missing data, and it will enter asterisks in these cells.</P> <P>How do we make use of this structure? It's very simple. Each time you run a procedure, you must first place the cursor anywhere within the data set. (You're always given a second chance to do so if you forget.) Then the procedure looks to the first row of the data set, reads the variable names, names each column with that variable name, fills in blank cells with asterisks, and then accomplishes its tasks. If you don't follow the structure explained in the previous two paragraphs, StatPro will very likely give you an error message or produce unanticipated results.</P> <P>Why do we impose this structure? In our opinion, one of the main strengths of Excel (or any other spreadsheet package) is also its main weakness when it comes to statistical tasks: It is too flexible! You can put anything anywhere and get away with it. It appears to us that developers of statistical add-ins

评论收藏

内容反馈