Solved

# Cronbach's Alpha

Posted on 2010-09-21
1,351 Views
Hi,

I want to test the reliability of my measurement model (The Technology Acceptance Model (Davis, F.D.)) using Cronbach's Alpha. I am completely unfamiliar with statistical methods and can't make head or tail of how Cronbach's Alpha maths work.

The Technology Acceptance Model has 3 main constructs that I have collected data:

Perceived Usefulness (PU)
Attitude (ATT)

I have surveyed 50 people with 13 questions:

6 questions relating to PU (PU1, PU2, PU3, PU4, PU5, PU6)
6 questions relating to PEoU (PEoU1, PEoU2, PEoU3, PEoU4, PEoU5, PEoU6)
1 question relating to ATT (ATT1)

Can I insert this into an Excel sheet and apply a formula? If so, how would I do this with the information above?

Or will I have to use stats software like Lisrel8.8 or AMOS5?
0
• 4
• 3

LVL 38

Accepted Solution

puppydogbuddy earned 500 total points
0

LVL 38

Expert Comment

http://libguides.princeton.edu/content.php?pid=27916&sid=456774
(click excel tab)
0

LVL 1

Author Comment

Don't ask me how there's only 50 points being awarded for this - There seemed to be a bug with the EE website last night when I posted my question. I've upgraded the question to 500.
0

LVL 1

Author Comment

Hi puppydogbuddy,

Apologies for asking this after closing the question - In the weblink:

http://www.sagepub.com/liustudy/chapters/08/UsingExceltoAnalyzeData.pdf

The author has a column titled "Key/Point". Do you know what this column is for?
0

LVL 1

Author Comment

Sorry, the column I'm referring to is in the excel sheet example on that webpage.
0

LVL 38

Expert Comment

I believe the Points column contains the maximum points for each item, which is factored into the computation of "item difficulty" .  See page 3 of  9.
0

LVL 1

Author Comment

Now that makes sense! Thanks again!
0

## Featured Post

Improved? Move/Copy Add-in Replacement - How to avoid the annoying, “A formula or sheet you want to move or copy contains the name XXX, which already exists on the destination worksheet.” David Miller (dlmille)  It was one of those days… I wa…
Ever wonder how to "do" object oriented programming (OOP)?
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.