Original Message on Regression
Title: - Original Message - - Original Message - From: Zina Taran [EMAIL PROTECTED] To: [EMAIL PROTECTED]; Ailc1 [EMAIL PROTECTED] Sent: Saturday, January 29, 2000 6:38 PM Subject: Re: Shareware for Computing Significance Level? just click on the field confidence level to have that field checked in the regression analysis menu (from data analysis) in Excel. That one is the 95% one though. if you want a different one, there are built-in functions which I don't remember off the top of my head. cheers, ZT - The EXCEL regression dialog box requests the following information: You have to install the analysis ToolPak add-in macro to get this About the Regression dialog box Input Y Range Enter the reference for the range of dependent data. The range must consist of a single column of data. Input X Range Enter the reference for the range of independent data. Microsoft Excel orders independent variables from this range in ascending order from left to right. The maximum number of independent variables is 16. Labels Select if the first row or column of your input range or ranges contains labels. Clear if your input has no labels; Microsoft Excel generates appropriate data labels for the output table. Confidence Level Select to include an additional level in the summary output table. In the box, enter the confidence level you want applied in addition to the default 95 percent level. Constant is Zero Select to force the regression line to pass through the origin. Output Range Enter the reference for the upper-left cell of the output table. Allow at least seven columns for the summary output table, which includes an anova table, coefficients, standard error of y estimate, r2 values, number of observations, and standard error of coefficients. New Worksheet Ply Click to insert a new worksheet in the current workbook and paste the results starting at cell A1 of the new worksheet. To name the new worksheet, type a name in the box. New Workbook Click to create a new workbook and paste the results on a new worksheet in the new workbook. Residuals Select to include residuals in the residuals output table. Standardized Residuals Select to include standardized residuals in the residuals output table. Residual Plots Select to generate a chart for each independent variable versus the residual. Line Fit Plots Select to generate a chart for predicted values versus the observed values. Normal Probability Plots Select to generate a chart that plots normal probability. --- >From above, the 95% is automatic, you have to enter another value, and you will get results corresponing to the new value IN ADDITION. For tests on the coefficients, apply the TDIST function to the cells containing the standard error values of the coefficients. TDIST has as inputs the cell containing the X value, the degrees of freedom, and then whether you want one tail (1) or two tail(2) tests. The function returns the p value DAH
Re: Shareware for Computing Significance Level?
On 01/29/00, [EMAIL PROTECTED] (Ailc1) said: Anyone know of shareware that computes significance level given degrees of freedom v1 and v2? The program Cupid computes critical values and significance levels (among other things) for many distributions, including the F, t, r, and ChiSquare. It is freeware for the PC, available at http://www.simtel.net/pub/simtelnet/msdos/statstcs/ http://garbo.uwasa.fi/pc/stat/ Look for cupid1_1.zip Jeff [EMAIL PROTECTED] http://psy.otago.ac.nz:800/staff/miller/welcome.htm === This list is open to everyone. Occasionally, people lacking respect for other members of the list send messages that are inappropriate or unrelated to the list's discussion topics. Please just delete the offensive email. For information concerning the list, please see the following web page: http://jse.stat.ncsu.edu/ ===
scoring semantic differential
After looking in Osgood, Suci, and Tannenbaum's "The Measurement of Meaning" and Snider and Osgood's "Semantic Differential Technique," plus several of Osgood's individual articles, I cannot find the answer to this simple question: In scoring the Semantic Differential, does one treat MISSING data (i.e., a scale to which a subject failed to give a response) as "null" or do you assign it the "middle value" of your scale (i.e, 4 on a 1-to-7 scale, or 0 in a -3-to-+3 scale)? Clearly, Osgood hints that if the response is "not applicable" then the middle scale is the answer. And NOT having any response (i.e., null) distorts the computation of the Osgood D, which is at the center of my research. Has anyone seen anything in the literature, or has your own work delivered any insights, which would cast light on this problem? Thank you for a quick reply, either here or (better) direct to my e-mail address! Grover Proctor Dean Northwood University [EMAIL PROTECTED] === This list is open to everyone. Occasionally, people lacking respect for other members of the list send messages that are inappropriate or unrelated to the list's discussion topics. Please just delete the offensive email. For information concerning the list, please see the following web page: http://jse.stat.ncsu.edu/ ===
Likert scale( nonmetric or metric scale)
Dear all I have seen articles in marketing and organization behavior journal using a likert scale to test a hypothesis by applying it as a metric scale (run regression as a dependent variable). In addition, some statistical books are presented a likert scale as an ordinal scale while a few books are represented it as an interval scale. Could anyone help me to make clear of it so we can use a likert scale with the right analysis tools? Any response will be highly appreciated. Regards, Boonlert W. === This list is open to everyone. Occasionally, people lacking respect for other members of the list send messages that are inappropriate or unrelated to the list's discussion topics. Please just delete the offensive email. For information concerning the list, please see the following web page: http://jse.stat.ncsu.edu/ ===