# Cronbach's Alpha

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?
LVL 1
###### Who is Participating?

Commented:
0

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

Author Commented:
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

Author Commented:
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

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

Commented:
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

Author Commented:
Now that makes sense! Thanks again!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.